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