Re: Duplicate primary key record - Mailing list pgsql-bugs

From Joel Jacobson
Subject Re: Duplicate primary key record
Date
Msg-id 1068980518.3fb75926a3239@mail.jacobson.be
Whole thread Raw
In response to Re: Duplicate primary key record  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Duplicate primary key record  (Gaetano Mendola <mendola@bigfoot.com>)
Re: Duplicate primary key record  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Hi Stephan,

Thanks for a quick reply.

pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024;
   oid   |   xmin    |   xmax    | userid  | balance  | reservedbalance |
modificationdate
---------+-----------+-----------+---------+----------+-----------------+------------------
 2080463 | 248152344 | 248307452 | 1002024 | 10000.00 |          154.02 |
1068947725
 2080463 | 248274508 | 248307402 | 1002024 | 10000.00 |          727.57 |
1068949964
(2 rows)

Please let me know if there is anything else that I can test.

Best regards,

Joel Jacobson

Citerar Stephan Szabo <sszabo@megazone.bigpanda.com>:
> Hmm, what does select oid,xmin,xmax,* where userid=1002024; give?

pgsql-bugs by date:

Previous
From: Dennis Bjorklund
Date:
Subject: Re: 7.5devel - duplicate error message
Next
From: John Griffiths
Date:
Subject: Re: RC2 will not make check on OSX 10.3