BUG #7760: records with duplicate primary keys

From: acummings(at)aperiogroup(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7760: records with duplicate primary keys
Date: 2012-12-19 17:22:05
Message-ID: E1TlNLJ-0004w4-IN@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7760
Logged by: Alan Cummings
Email address: acummings(at)aperiogroup(dot)com
PostgreSQL version: 9.1.7
Operating system: Ubuntu Linux 10.04.1
Description:

We found 6 duplicated primary keys in a table. All fields were identical in
the duplicated records, including the primary key. (Total records ~ 22,000).
We recently updated from 9.1.2 to 9.1.7, so the issue may have been present
in 9.1.2.

We have fixed the issue in our table by backing up the table in pgAdmin to a
plain file, deleting the duplicated records in the text file, then restoring
the table.

I can send the original backup with the duplicated records if that would be
helpful -- it is about 11MB.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-12-19 19:08:45 Re: BUG #7758: pg_dump does not correctly dump operators.
Previous Message dmigowski 2012-12-19 10:31:59 BUG #7758: pg_dump does not correctly dump operators.