Re: [BUGS] Problem with restoring database from a pg_dump generated script.

2001-05-11 Thread Tom Lane
"Jerry Davis" <[EMAIL PROTECTED]> writes: > CREATE SEQUENCE login_primary_key_seq start 1 increment 1 maxvalue > 2147483647 minvalue 1 cache 1 ; > SELECT nextval ('login_primary_key_seq'); > Is there something missing from the original database that got > dumped, or something I have to manually

[BUGS] Problem with restoring database from a pg_dump generated script.

2001-05-11 Thread Jerry Davis
In short, when I try to restore a database from a pg_dump generated SQL script, then try to insert additional records into the restored datbase, it gives me a duplicate key error. I am using the following version of the PostgreSQL database: PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc