Re: BUG #8382: Duplicate primary key

From: Greg Stark <stark(at)mit(dot)edu>
To: curd(dot)reinert(at)ppi(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8382: Duplicate primary key
Date: 2013-08-14 10:44:40
Message-ID: CAM-w4HMCRve_R5JTZZTaDE-HJOstux2aWxcJ=KuPomR9wz9oXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Aug 13, 2013 at 2:50 PM, <curd(dot)reinert(at)ppi(dot)de> wrote:
> I do have a copy of the data directory with a duplicate row in
> cluster_ressource, in case anyone wants to dive into it.

Could you run the following?

select ctid,xmin,xmax,primarykey from tab where primarykey = 'duplicatevalue'

And also show the \d tab output?

And can you load the pageinspect contrib module in this database?

--
greg

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Curd Reinert 2013-08-14 11:32:07 Re: BUG #8382: Duplicate primary key
Previous Message aschetinin 2013-08-14 10:13:59 BUG #8383: SQL statement error log misses query parameters