On Mon, 28 Jan 2008 14:11:21 -0800 "Dann Corbit" <DCorbit@xxxxxxxxx> wrote: > > -----Original Message----- > > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > > owner@xxxxxxxxxxxxxx] On Behalf Of John Gateley > > Sent: Monday, January 28, 2008 2:04 PM > > To: pgsql-general@xxxxxxxxxxxxxx > > Subject: 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 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 linked to the first > > table's ID 1). > > Because of the nature of the values of the id's (1 and 123456) it sounds > very much like a manual insertion. Is there a unique index on the > column? It definitely sounds like there should be. At any rate, I > guess that someone manually inserted the data. Without a unique index > on the column, there is no protection against this. Yes, the id 1 definitely indicates to me that I did something. However, there is an index on the column: it's the primary key for the table. I'm not sure how I could manually insert it if there were an existing index, or later create the index if it didn't exist when I did the insert. Thanks, j -- John Gateley <gateley@xxxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
