Re: Dump

From: Mihai Gheorghiu <tanhq(at)bigplanet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump
Date: 2000-06-07 14:42:22
Message-ID: 000c01bfd08e$97f34820$c39c103f@new6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

All tables have names starting in tbl - they were exported from Access using
the public domain ODBC drivers.
Could the problem originate here?

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

Browse pgsql-general by date

  From Date Subject
Next Message Vince Vielhaber 2000-06-07 14:55:19 Re: anoncvs access
Previous Message Tom Lane 2000-06-07 14:41:53 Re: anoncvs access