Re: BUG #2379: Duplicate pkeys in table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org, Michael Fuhr <mike(at)fuhr(dot)org>, alvherre(at)commandprompt(dot)com
Subject: Re: BUG #2379: Duplicate pkeys in table
Date: 2006-04-06 14:24:15
Message-ID: 17857.1144333455@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> # 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)

For completeness, could we also see ctid in that query?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-06 14:27:23 Re: BUG #2379: Duplicate pkeys in table
Previous Message Alvaro Herrera 2006-04-06 13:42:39 Re: Problema Order By en PosgreSQL 8.1