Re: Table has duplicate keys, what did I do

On Mon, 28 Jan 2008 21:36:35 -0500
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.
> > ...
> > But, mostly, I'm wondering how I managed to get in this state,
>
> 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.

Thanks,

j

--
John Gateley <gateley@jriver.com>