Re: BUG #15159: Duplicate records for same primary key - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #15159: Duplicate records for same primary key
Date
Msg-id CAH2-WzkN1kwjj17vQVD=yzM4G1cOdS_0zNfUJYgDm_aJWHRm6A@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15159: Duplicate records for same primary key  ("K S, Sandhya (Nokia - IN/Bangalore)" <sandhya.k_s@nokia.com>)
Responses Re: BUG #15159: Duplicate records for same primary key
List pgsql-bugs
On Wed, Apr 18, 2018 at 3:10 AM, K S, Sandhya (Nokia - IN/Bangalore)
<sandhya.k_s@nokia.com> wrote:
> Also will postgres has any logs which could be used to identify if this bug has appeared ?

This kind of thing that amcheck's "heapallindexed" option can detect,
which will appear in Postgres 11. You can get a version with
equivalent functionality that targets earlier Postgres releases from
Github (there are official PGDG packages for most Linux systems). The
heapallindexed check can verify that the heap is consistent with
indexes.

-- 
Peter Geoghegan


pgsql-bugs by date:

Previous
From: "K S, Sandhya (Nokia - IN/Bangalore)"
Date:
Subject: Re: BUG #15159: Duplicate records for same primary key
Next
From: Andreas Karlsson
Date:
Subject: Ignored join clause