Search Postgresql Archives

Re: Table has duplicate keys, what did I do

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux