From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | Dave Smith <dave(dot)smith(at)candata(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Vacuum Error |
Date: | 2004-01-12 19:25:13 |
Message-ID: | 1073935513.4002f499d4101@bugs.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
---------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-01-12 19:52:19 | Re: Drawbacks of using BYTEA for PK? |
Previous Message | Cláudia Morgado | 2004-01-12 19:12:25 | Pass data of database Oracle to PostgreSQL |