What versions of PostgreSQL are you using? I've observed some
changes in the handling of serial columns in backup/restore from
version 7.x to 8.x. It is possible that your sequences aren't being
restored correctly. It would be pretty easy to manually set starting
sequence values. It is
Hi,
when we are using the postgreSQL in one system and
inserting data in the table.when we are taking the backup of the postgresql
Database and Restoring in another system and inserting the data in the table
in the restored system then this error is coming "Duplicate Key Insert
