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 |
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 |