Dump

From: Trurl McByte <trurl(at)realtor3d(dot)odessa(dot)ua>
To: pgsql-general(at)postgresql(dot)org
Subject: Dump
Date: 2000-06-07 13:31:30
Message-ID: Pine.LNX.4.20.0006071626290.2269-100000@trurl.anything3d.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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--|

In response to

  • Dump at 2000-06-06 19:02:19 from Mihai Gheorghiu

Responses

  • Re: Dump at 2000-06-07 15:30:20 from Tom Lane

Browse pgsql-general by date

  From Date Subject
Next Message Mihai Gheorghiu 2000-06-07 14:05:12 Re: Dump
Previous Message Andrew Sullivan 2000-06-07 13:30:05 Re: getting inet out of char?