Re: Vacuum Error - Mailing list pgsql-general

From Martin Marques
Subject Re: Vacuum Error
Date
Msg-id 1073935513.4002f499d4101@bugs.unl.edu.ar
Whole thread Raw
In response to Vacuum Error  (Dave Smith <dave.smith@candata.com>)
List pgsql-general
Mensaje citado por Dave Smith <dave.smith@candata.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
---------------------------------------------------------

pgsql-general by date:

Previous
From: Dave Smith
Date:
Subject: Vacuum Error
Next
From: "scott.marlowe"
Date:
Subject: Re: Drawbacks of using BYTEA for PK?