Re: BUG #8382: Duplicate primary key - Mailing list pgsql-bugs

From Greg Stark
Subject Re: BUG #8382: Duplicate primary key
Date
Msg-id CAM-w4HMCRve_R5JTZZTaDE-HJOstux2aWxcJ=KuPomR9wz9oXA@mail.gmail.com
Whole thread Raw
In response to BUG #8382: Duplicate primary key  (curd.reinert@ppi.de)
Responses Re: BUG #8382: Duplicate primary key
List pgsql-bugs
On Tue, Aug 13, 2013 at 2:50 PM,  <curd.reinert@ppi.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

pgsql-bugs by date:

Previous
From: "ascot.moss@gmail.com"
Date:
Subject: Re: Recovery.conf PITR by recovery_target_time
Next
From: Curd Reinert
Date:
Subject: Re: BUG #8382: Duplicate primary key