Re: BUG #2379: Duplicate pkeys in table

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2379: Duplicate pkeys in table
Date: 2006-04-06 14:39:08
Message-ID: 4435280C.7000003@rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Philip Warner 2006-04-06 14:40:02 Re: BUG #2379: Duplicate pkeys in table
Previous Message Alvaro Herrera 2006-04-06 14:27:23 Re: BUG #2379: Duplicate pkeys in table