Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-29 Thread Tom Lane
John Gateley <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> wrote: >> 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? > Yes,

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-29 Thread John Gateley
On Tue, 29 Jan 2008 12:53:11 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > John Gateley <[EMAIL PROTECTED]> writes: > > Tom Lane <[EMAIL PROTECTED]> wrote: > >> John Gateley <[EMAIL PROTECTED]> writes: > >>> Somehow I have managed to have two tables with duplicate keys. > > >> What PG version is th

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-29 Thread Tom Lane
John Gateley <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> wrote: >> John Gateley <[EMAIL PROTECTED]> 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.

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-29 Thread John Gateley
On Mon, 28 Jan 2008 21:36:35 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > John Gateley <[EMAIL PROTECTED]> 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

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-28 Thread Tom Lane
John Gateley <[EMAIL PROTECTED]> 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.

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-28 Thread Li, Jingfa
x27;t turn back on the unique constrain validation... JF -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Gateley Sent: Monday, January 28, 2008 2:26 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Table has duplicate keys, what did I do O

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-28 Thread Scott Marlowe
gt; [EMAIL PROTECTED] On Behalf Of John Gateley > > > Sent: Monday, January 28, 2008 2:04 PM > > > To: pgsql-general@postgresql.org > > > Subject: [GENERAL] Table has duplicate keys, what did I do > > > > > > Somehow I have managed to have two tables with dup

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-28 Thread John Gateley
; To: pgsql-general@postgresql.org > > Subject: [GENERAL] Table has duplicate keys, what did I do > > > > Somehow I have managed to have two tables with duplicate keys. > > In both tables, the key is an integer, filled from a sequence. > > There is only 1 duplicated en

Re: [GENERAL] Table has duplicate keys, what did I do

2008-01-28 Thread Dann Corbit
> -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of John Gateley > Sent: Monday, January 28, 2008 2:04 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Table has duplicate keys, what did I do > > Someho

[GENERAL] Table has duplicate keys, what did I do

2008-01-28 Thread John Gateley
Somehow I have managed to have two tables with duplicate keys. In both tables, the key is an integer, filled from a sequence. There is only 1 duplicated entry in each table: in the first table, there are two ID "1"s, and in the second table there are two ID "123456"s (the second table entry is link