Re: [GENERAL] My database hurts "ERROR: duplicate key violates unique constraint"

2004-05-07 Thread Tom Lane
Mike Hunter <[EMAIL PROTECTED]> writes: > After a recent power failure, a program that uses a pgsql backend > (netdisco) started to send me nastygrams. Hmm. Try REINDEX on the index involved. regards, tom lane ---(end of broadcast)

[GENERAL] My database hurts "ERROR: duplicate key violates unique constraint"

2004-05-07 Thread Mike Hunter
(Please CC me on any replies as I'm not on the list) Hi, After a recent power failure, a program that uses a pgsql backend (netdisco) started to send me nastygrams. I tried the author's suggestion of running a VACUUM FULL ANALYZE VERBOSE;, but it still sends me the messages. The data in the dat