Re: Duplicate primary key record

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Cc: Joel Jacobson <joel(at)jacobson(dot)be>
Subject: Re: Duplicate primary key record
Date: 2003-11-16 17:01:29
Message-ID: 3FB7AD69.10806@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joel Jacobson 2003-11-16 17:30:35 Re: Duplicate primary key record
Previous Message John Griffiths 2003-11-16 14:48:59 Re: RC2 will not make check on OSX 10.3