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