Re: BUG #2379: Duplicate pkeys in table - Mailing list pgsql-bugs

From Philip Warner
Subject Re: BUG #2379: Duplicate pkeys in table
Date
Msg-id 4435280C.7000003@rhyme.com.au
Whole thread Raw
In response to Re: BUG #2379: Duplicate pkeys in table  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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)

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table
Next
From: Philip Warner
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table