Re: Creating serial ID on Windows.

Ardian Xharra (Boxxo) wrote:
> I'm having some troubles restoring a database on Windows and I found
> this difference between PostgreSQL running on Linux and Windows.
> When I create a table like this:
> CREATE TABLE fee_payment1(id_fee_payment1 serial NOT NULL) WITH OIDS;
> On Linux platform it will be:
> CREATE TABLE fee_payment1 (  id_fee_payment1 serial NOT NULL) WITH OIDS;
> And on Windows platform is:
> CREATE TABLE fee_payment1
> (  id_fee_payment1 int4 NOT NULL DEFAULT
> nextval('fee_payment1_id_fee_payment1_seq'::regclass) ) WITH OIDS;
> So, I would like to know if this would have an impact throught restoring
> database.

Postgres doesn't care (in this regard anyway) what platform you are running.

There will be no difference between creating the table on windows to linux.

--
Postgresql & php tutorials
http://www.designmagick.com/