Horton

Re: BUG #2379: Duplicate pkeys in table

Philip Warner <pjw@rhyme.com.au>

View thread
From: Philip Warner <pjw@rhyme.com.au>
To: pgsql-bugs@postgresql.org
Date: 2006-04-06T14:39:08Z
Lists: pgsql-bugs 
Tom Lane wrote:
> For completeness, could we also see ctid in that query?
mail=# set enable_indexscan=off;
mail=# SELECT xmin, xmax, cmin, cmax,ctid FROM xxx where id = 24613;
   xmin   |   xmax   | cmin |   cmax   |  ctid
----------+----------+------+----------+---------
 32902771 |        0 |   20 | 32902872 |   (0,7)
 32902771 |        0 |   20 | 32902872 |  (2,27)
 32902771 |        0 |   20 | 32902872 | (58,27)
 32902771 |        0 |   20 | 32902872 | (60,28)
 32902771 |        0 |   20 | 32902872 |  (69,3)
 32902771 | 33048159 |   20 |       20 | (72,27)
(6 rows)