Re: duplicate key violates unique constraint. (repost)

Michael Guerin <guerin@rentec.com> writes:
> We're starting to get a number of complaints about "duplicate key
> violations" on a index for one of the toast tables.  It started
> happening after our server was brought down over the weekend, so I
> suspect postgresql wasn't shutdown properly.  Below is the description
> of the index.

> I'm doing a re-index on the user table that is associated with the toast
> table, is this the right thing to do?  Is there something else I should do?

I don't think that will touch the toast table --- you should reindex the
toast table or index explicitly.

            regards, tom lane