From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | y(dot)chaitanya(at)tcs(dot)com |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13862: Duplicated rows for a table with primary key |
Date: | 2016-01-14 15:22:57 |
Message-ID: | CAKFQuwYQUydjUJdU=r9Ywh2QWqJ1rFqZ9NpA6uHCqwsy1=DAbA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | y.chaitanya | 2016-01-14 15:50:29 | Re: BUG #13862: Duplicated rows for a table with primary key |
Previous Message | 閬閬イふ | 2016-01-14 13:04:00 | about test_parser installation failure problem(PostgreSQL in 9.5.0)? |