Re: Duplicate Data insertion

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
doug@oakstreetsoftware.com
(910) 526-5938