Re: duplicate key in unique index pg_statistic_relid_att_index

"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