Re: Table has duplicate keys, what did I do

John Gateley <gateley@jriver.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> John Gateley <gateley@jriver.com> writes:
>>> Somehow I have managed to have two tables with duplicate keys.

>> What PG version is this?  We've fixed some bugs in the past that
>> could give rise to duplicated rows.

> Currently 8.1.4, and it's been tracking Ubuntu 6.06 LTS for
> updates, so it could have been earlier than 8.1.4 when the duplicate
> row actually was created.

There was a fix released in 8.1.9 for a problem that could cause VACUUM
FULL to create duplicate copies of a row that had recently been updated.
Does that sound like a plausible scenario for your usage?

            regards, tom lane