pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Harald Lau <harald@sector-x.de>
To: pgsql-performance@postgresql.org
Subject: URGENT: pg_statistic_relid_att_index has gone
Date: Mon, 03 Oct 2005 14:27:54 +0200
Message-ID: <434123CA.2020708@sector-x.de> (raw)
In-Reply-To: <20051003110226.GA26883@uio.no>
References: <20051003110226.GA26883@uio.no>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

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?

tia,
Harald
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: GnuPT 2.7.2

iQEVAwUBQ0Ejx3fX3+fgcdKcAQIVoQf+MFnt+U65FPNxQjHwZ15eT13NwBoCsOE9
d3nFaKTG58SmI9QziMt1Tpo+pD89LMQZacnCRDv/M3Tz6ruSQaPIsxS6m1evKjq7
7ixSRCwD+41C2x27qSRZDOEUt6AvG5xfSv43NxJQNS/zB+/TnQ3wGXzwdRrRQiQE
Mv6DXv5s+3Wrbg9qG78Xn3mHOGGySFSG1x9ItUoST+jC6a7rOl5YL3wDCacdgve/
pzq3fe6+JYjEQyKFxEzZYJidsWvr9C7EKfc321PYBscuPNyGMU1Vohe8kDYFbyeG
L23jXPV8c7WO2w4aQMdQr6V9YXtnBeMgGdAFjo4My29xbdepkwOUvw==
=I8Ax
-----END PGP SIGNATURE-----



view thread (3+ messages)  latest in thread

Message-ID: <434123CA.2020708@sector-x.de>
Permalink:  ../434123CA.2020708@sector-x.de/
Also on:    postgresql.org/message-id/434123CA.2020708@sector-x.de

 · 

reply

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: harald@sector-x.de
  Subject: Re: URGENT: pg_statistic_relid_att_index has gone
  In-Reply-To: <434123CA.2020708@sector-x.de>

* 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