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