| 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: | Whole Thread | Raw Message | 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 |