--0-796592149-1210343773=:30351
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hello,=0AI 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
ha=
ppen, not sure is a postgres bug or not.=0AI got a table call
CS_SR_MTHLY_R=
TN which has=A0MTHLY_RTN_ID (INTEGER) as a primary key. So the
MTHLY_RTN_ID=
value should be unique, but somehow=A0there are 2 record which id is 15
in=
this table. =0AThe 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
a=
re 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.=0AHo=
w can this happen? =0ACurrently using Postgres 8.2.5=0ARegards=0ALouis
--0-796592149-1210343773=:30351
Content-Type: text/html; charset=us-ascii
<html><head><style type="text/css"><!-- DIV {margin:0px;}
--></style></head><body><div style="font-family:arial, helvetica,
sans-serif;font-size:12pt"><DIV>Hello,</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>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. </DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>How can this happen? </DIV>
<DIV> </DIV>
<DIV>Currently using Postgres 8.2.5</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards</DIV>
<DIV>Louis</DIV></div></body></html>
--0-796592149-1210343773=:30351--
|
