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