Re: Duplicate primary key record

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)
>
> Please let me know if there is anything else that I can test.

This happen a few time to me too and I solved not running anymore
each night a REINDEX on the table. I posted this problem in the
past ...

Do you scedule reindex on this table very often ?


Regards
Gaetano Mendola