Re: BUG #13862: Duplicated rows for a table with primary key

On Thu, Jan 14, 2016 at 5:18 AM, <y(dot)chaitanya(at)tcs(dot)com> wrote:

>
>
> From: Y Chaitanya/CHN/TCS
> To: "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
> Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
> Date: 14-01-16 04:27 PM
> Subject: Re: [BUGS] BUG #13862: Duplicated rows for a table with
> primary key
> ------------------------------
>
>
> HI David,
> Thanks for the reply,
>
> Yes I agree that it is old version, But can you let us know if there are
> any old bugs that violates the primary key.
>
>
This is why we have release notes.

If nothing there gives you a clue then the two screenshots you've provided
are insufficient diagnostic - though they do indeed show that at some point
you had a problem.

A simple action to take is to remove all duplicates and then reindex. It
may be simple corruption at hand. It happens - usually due to hardware
issues.

David J.