Creating serial ID on Windows.

From: "Ardian Xharra (Boxxo)" <axharra(at)boxxo(dot)info>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Creating serial ID on Windows.
Date: 2006-03-27 15:06:36
Message-ID: 013501c651b0$0b2a66e0$6a01a8c0@BOXXO.ARDIAN
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Attachment Content-Type Size
unknown_filename text/plain 144 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-27 15:22:49 Re: [GENERAL] PANIC: heap_update_redo: no block
Previous Message Tony Caduto 2006-03-27 15:05:53 ACL question