Re: Duplicate primary key record

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?