Dump - Mailing list pgsql-general

From Trurl McByte
Subject Dump
Date
Msg-id Pine.LNX.4.20.0006071626290.2269-100000@trurl.anything3d.com
Whole thread Raw
In response to Dump  (Mihai Gheorghiu <tanhq@bigplanet.com>)
Responses Re: Dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

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


--
      Trurl McByte, Capt. of StasisCruiser "Prince"
|InterNIC: AR3200                   RIPE: AR1627-RIPE|
|--98 C3 78 8E 90 E3 01 35  87 1F 3F EF FD 6D 84 B3--|


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: getting inet out of char?
Next
From: Mihai Gheorghiu
Date:
Subject: Re: Dump