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
Cc: Michael Fuhr <mike@fuhr.org>, alvherre@commandprompt.com
Date: 2006-04-06T13:03:23Z
Lists: pgsql-bugs 
Michael Fuhr wrote:
> On Thu, Apr 06, 2006 at 08:12:31AM -0400, Alvaro Herrera wrote:
>   
>> Please do a
>>
>> SELECT xmin, xmax, cmin, cmax FROM xxx where id = 24613;
>>     
# set enable_indexscan=off;
# SELECT xmin, xmax, cmin, cmax FROM xxx where id = 24613;
   xmin   |   xmax   | cmin |   cmax
----------+----------+------+----------
 32902771 |        0 |   20 | 32902872
 32902771 |        0 |   20 | 32902872
 32902771 |        0 |   20 | 32902872
 32902771 |        0 |   20 | 32902872
 32902771 |        0 |   20 | 32902872
 32902771 | 33048159 |   20 |       20
(6 rows)