Re: Vacuum Error

Mensaje citado por Dave Smith <dave(dot)smith(at)candata(dot)com>:

> I am running 7.2 and when doing a vacuum I am getting the following
> error....
>
> ERROR: Cannot insert a duplicate key into unique index
> pg_statistic_relid_att_index
>
>
> Where do I start to fix this?

I'm not 100% about this working, but I would try to rebuild the index:

REINDEX pg_statistic_relid_att_index

You have to be the postgres superuser to do this.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
---------------------------------------------------------
Martín Marqués | Programador, DBA
Centro de Telemática | Administrador
Universidad Nacional
del Litoral
---------------------------------------------------------