Re: 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.

Details:
Table description as below with network_element_pk column having primary
key.

Due to some reason, may be due to large transactions, (frequently) the
rows got duplicated as below, Let me know if you need any more details.

Best Regards
Krishna Chaitanya
Tata Consultancy Services
Mailto: y(dot)chaitanya(at)tcs(dot)com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Consulting
____________________________________________

From: "David G. 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>
Date: 14-01-16 12:57 AM
Subject: Re: [BUGS] BUG #13862: Duplicated rows for a table with
primary key

On Wed, Jan 13, 2016 at 9:51 AM, <y(dot)chaitanya(at)tcs(dot)com> wrote:
The following bug has been logged on the website:

Bug reference: 13862
Logged by: krishna chaitanya
Email address: y(dot)chaitanya(at)tcs(dot)com
PostgreSQL version: 9.1.2
Operating system: SUSE Linux E nterprise Server 11 SP2
Description:

we have an issue in production server where the tables with primary key
constraint are duplicated. Complete row is duplicated with identical
values
.

So please help us to know the root cause for this. We are able to delete
the
duplicates, but not sure what cause this issue

You are going to have to provide more information​ than this.

You are also using an ancient 9.1 release; 9.1.19 is current.

David J.

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you