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