Postgres Pro
Downloads
Home   >   mailing lists

Re: Table has duplicate keys, what did I do - Mailing list pgsql-general

From John Gateley
Subject Re: Table has duplicate keys, what did I do
Date
Msg-id 20080129095714.df7013c5.gateley@jriver.com
Whole thread Raw
In response to Re: Table has duplicate keys, what did I do  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Table has duplicate keys, what did I do  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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>

pgsql-general by date:

Previous
From: "Vlad Marchenko"
Date:
Subject: Re: 8.3RC2 vs 8.2.6 testing results
Next
From: David Fetter
Date:
Subject: Re: OT - pg perl DBI question