Re: BUG #2379: Duplicate pkeys in table

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, alvherre(at)commandprompt(dot)com
Subject: Re: BUG #2379: Duplicate pkeys in table
Date: 2006-04-06 13:03:23
Message-ID: 4435119B.8000002@rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-06 13:42:39 Re: Problema Order By en PosgreSQL 8.1
Previous Message Michael Fuhr 2006-04-06 12:20:21 Re: BUG #2379: Duplicate pkeys in table