Trurl McByte <trurl@realtor3d.odessa.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