Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group