Re: Duplicate primary key record

From: Joel Jacobson <joel(at)jacobson(dot)be>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Duplicate primary key record
Date: 2003-11-16 11:01:58
Message-ID: 1068980518.3fb75926a3239@mail.jacobson.be
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Best regards,

Joel Jacobson

Citerar Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>:
> Hmm, what does select oid,xmin,xmax,* where userid=1002024; give?

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Griffiths 2003-11-16 14:48:59 Re: RC2 will not make check on OSX 10.3
Previous Message Dennis Bjorklund 2003-11-16 10:09:20 Re: 7.5devel - duplicate error message