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 pretty hard to offer any concrete advise
without knowing what version of code you're running on both systems.
You might also tell us what platform(s) you are using.
On Jun 14, 2007, at 5:26 AM, Ponmalar Dhanuskodi wrote:
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.sequence number is not changing.Please give any suggestions.
With Regards,
Ponmalar.D
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
