Re: [GENERAL] please help me recover from duplicate key in unique index

Charles Martin wrote:

> Please help me recover our database from what I think
> is a duplicate key in unique index problem.

This may not help, and forgive my asking the obvious, but have
you done a SELECT on the table and actually *seen* duplicate 'id'
values in the SERIAL column? That would surprise me because I
didn't think it was possible to create duplicates in the scenario
you describe. The SERIAL type is really just a sequence, and its
values are unique across all transactions (I hope!). IIRC there
is some opportunity for wierdness if the sequence cache setting
has been "adjusted" incorrectly
(http://www.postgresql.org/docs/postgres/sql-createsequence.htm).

> When I try to vacuum, I get this:
>
> ERROR: Cannot insert a duplicate key into a unique
> index
>

I didn't realize vacuum tried to insert anything. Maybe a system
table insert?

Cheers,
Ed Loehr