Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE
Date
Msg-id 28230.1002638045@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cannot insert duplicate... on VACUUM ANALYZE  (Jon Lapham <lapham@extracta.com.br>)
List pgsql-general
Tree view 
Jon Lapham <lapham@extracta.com.br> writes:
> When running a routine VACUUM ANALYZE on one of our databases (pg
> v7.1.2) the following message appears:

> main_v0_8=# VACUUM ANALYZE ;
> ERROR:  Cannot insert a duplicate key into unique index admin_users_pkey

Looks like you have a corrupted index.  What is that index on, exactly?
And what's your platform?

            regards, tom lane

pgsql-general by date:

Previous
From: Jon Lapham
Date:
Subject: ERROR: cannot insert duplicate... on VACUUM ANALYZE
Next
From: "Ryan C. Bonham"
Date:
Subject: Update View