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