Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lapham(at)extracta(dot)com(dot)br
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: cannot insert duplicate... on VACUUM ANALYZE
Date: 2001-10-09 14:34:05
Message-ID: 28230.1002638045@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jon Lapham <lapham(at)extracta(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin HaleBoyes 2001-10-09 14:47:53 triggers
Previous Message Eric D Nielsen 2001-10-09 14:26:49 Postgres --with-python problems..