Re: Table has duplicate keys, what did I do

John Gateley <gateley(at)jriver(dot)com> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> John Gateley <gateley(at)jriver(dot)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