Skip site navigation (1) Skip section navigation (2)

Duplicate Data insertion

From: "Ponmalar Dhanuskodi" <ponmalar(dot)ttcpl(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Duplicate Data insertion
Date: 2007-06-14 09:26:46
Message-ID: 421d02fc0706140226m1cd2f328ubb87c9125e980203@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Douglas ToltzmanDate: 2007-06-14 11:13:22
Subject: Re: Duplicate Data insertion
Previous:From: Magnus HaganderDate: 2007-06-14 09:07:53
Subject: Re: BUG #3385: Memory leak

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group