Duplicated primary key id happen - Mailing list pgsql-general

From mailtolouis2020-postgres@yahoo.com
Subject Duplicated primary key id happen
Date
Msg-id 739837.55207.qm@web30408.mail.mud.yahoo.com
Whole thread Raw
List pgsql-general
Hello,
 
I got a problem to restore a database, because there is a problem in my production database, which not suppose to happen like that, but it happen, not sure is a postgres bug or not.
 
I got a table call CS_SR_MTHLY_RTN which has MTHLY_RTN_ID (INTEGER) as a primary key. So the MTHLY_RTN_ID value should be unique, but somehow there are 2 record which id is 15 in this table.
 
The first record look fine to me, because the data in other columns look ok. But the second one, definitely I'm sure is wrong. There are value in column sr_batch_id and er_batch_id, and the value are very very big, 808464726 & 842018867 and the rest of the column value are null.
 
How can this happen?
 
Currently using Postgres 8.2.5
 
 
Regards
Louis

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: reproducible database crash with simple sql command on postgres 8.3.1
Next
From: mailtolouis2020-postgres@yahoo.com
Date:
Subject: Duplicated primary key id happen