Postgres Pro
Downloads
Home   >   mailing lists

Re: URGENT: pg_statistic_relid_att_index has gone - Mailing list pgsql-performance

From Tom Lane
Subject Re: URGENT: pg_statistic_relid_att_index has gone
Date
Msg-id 21820.1128348494@sss.pgh.pa.us
Whole thread Raw
In response to URGENT: pg_statistic_relid_att_index has gone  (Harald Lau <harald@sector-x.de>)
List pgsql-performance
Tree view 
Harald Lau <harald@sector-x.de> writes:
> on a 7.2 System (Suse-Linux) I got an error "duplicate key in unique
> index pg_statistic_relid_att_index" (think it was while vacuuming)
> I REINDEXd the database.
> Now the table pg_statistic_relid_att_index is completely gone.
> Has anybody an advise?

Dump, initdb, reload.  You've probably got more problems than just
that.  This might be a good time to update to something newer than
PG 7.2, too.

            regards, tom lane

pgsql-performance by date:

Previous
From: Harald Lau
Date:
Subject: Re: URGENT: pg_statistic_relid_att_index has gone
Next
From: Steven Rosenstein
Date:
Subject: Alternative to a temporary table