Re: Duplicate primary key record

On Sun, 16 Nov 2003, Joel Jacobson wrote:

> 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)

Hmm, in this case it looks to me like you literally have two versions of
the same row rather than two different rows with duplicate primary key
values. I'm not really sure what would have caused that, but I think it's
come up before (but I can't remember the discussion), so you might want to
check the archives.