From: Tom Lane <tgl@sss.pgh.pa.us>
To: Harald Lau <harald@sector-x.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: URGENT: pg_statistic_relid_att_index has gone
Date: Mon, 03 Oct 2005 10:08:14 -0400
Message-ID: <21820.1128348494@sss.pgh.pa.us> (raw)
In-Reply-To: <434123CA.2020708@sector-x.de>
References: <20051003110226.GA26883@uio.no>
<434123CA.2020708@sector-x.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, harald@sector-x.de
Subject: Re: URGENT: pg_statistic_relid_att_index has gone
In-Reply-To: <21820.1128348494@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox