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
