From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Trurl McByte <trurl(at)realtor3d(dot)odessa(dot)ua> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Dump |
Date: | 2000-06-07 15:30:20 |
Message-ID: | 3872.960391820@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Trurl McByte <trurl(at)realtor3d(dot)odessa(dot)ua> writes:
> Error in dumpig defaults on serial type!
> If table name have non-statndart name (example: "Order")
> sequenser auto created with name "Order_id_seq".
> In the dump filed definition is:
> ...
> "id" int4 DEFAULT nextval ( 'Order_id_seq' ) NOT NULL,
> ...
> , but need:
> ...
> "id" int4 DEFAULT nextval ( '"Order_id_seq"' ) NOT NULL,
> ...
Hmm. This is not pg_dump's fault: the default expression is actually
being stored that way in the database. Someone seems to have thought
it was a good idea to strip the double quotes at parse time instead
of run time :-(.
Will fix for 7.1 ... in the meantime, don't name your sequences that way
...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ed Loehr | 2000-06-07 15:37:14 | Re: [SQL] oracle rownum equivalent? |
Previous Message | David Reid | 2000-06-07 15:24:21 | Diff's |