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

On Fri, Jan 15, 2016 at 1:56 AM, <y(dot)chaitanya(at)tcs(dot)com> wrote:

> HI David,
>
> Thanks for your time,
>
> For us , the basic primary key feature is violated, So there must be
> some reason for this, Please let me know if you need any other information
> for finding the root cause.
> Also some advice to avoid this will be helpful.
>

​I neither have the time nor expertise to play email technical support for
an issue like this. Upgrade to the newest patch release, remove the
duplicates, and reindex. If the problem recurs turn on detailed logging
and try to isolate the process and related queries that is introducing the
duplicates.

​Or just wait around and see if someone else wants to pick up torch and
help you for free.

Or contact a professional services company and pay someone to do the same.

The community does take pride in the quality of its software but if you
cannot provide a re-producible test case on the most recent release of
PostgreSQL no one is going to be able to fix the problem should one even
exist. It is most likely assumed to either already have been fixed in a
more recent release or the cause is isolated to something that is unique to
your situation or a transient issue that can be cleared up using the tools
(e.g., reindex) provided.

David J.