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 Insertion"
because the bigserial we are declaring in the table is incremented 10 for
example in backup system and in the system we restored the serial is again
starting from 1 then this error is displayed.In the restored system even if
the table contains 10 records the sequence number is showing
1.sequencenumber is not
changing.Please give any suggestions.
With Regards,
Ponmalar.D