Re: duplicate key in unique index pg_statistic_relid_att_index - Mailing list pgsql-general

From Tom Lane
Subject Re: duplicate key in unique index pg_statistic_relid_att_index
Date
Msg-id 255.1036002184@sss.pgh.pa.us
Whole thread Raw
In response to duplicate key in unique index pg_statistic_relid_att_index  ("Andrew Bartley" <abartley@evolvosystems.com>)
List pgsql-general
"Andrew Bartley" <abartley@evolvosystems.com> writes:
> On a regular basis now I am getting duplicate keys in unique index pg_stati=
> stic_relid_att_index.

This is most curious.  AFAICS it should not be possible.

> Could this be cause by in insert into a table that i=
> s being "vacuum analyse" 'd ?

Nope.

> I have tried reindexing the database, but it always fails because there are=
>  duplicate rows in pg_statisitic.

Do a "DELETE FROM pg_statistic" and then re-analyze everything; should
fix it.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: permission prob: granted, but still denied
Next
From: Andrew Overholt
Date:
Subject: Re: Can't start rhdb-admin