Search Postgresql Archives

Creating serial ID on Windows.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.3.2/293 - Release Date: 26/03/2006

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux