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 4435119B.8000002@rhyme.com.au
Whole thread Raw
In response to Re: BUG #2379: Duplicate pkeys in table  (Michael Fuhr <mike@fuhr.org>)
Responses Re: BUG #2379: Duplicate pkeys in table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #2379: Duplicate pkeys in table  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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)

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table
Next
From: Jim Nasby
Date:
Subject: Re: PostgreSQL 8.1.3.6044 crashes randomly.