From: Harald Lau <harald@sector-x.de>
To: pgsql-performance@postgresql.org
Subject: Re: URGENT: pg_statistic_relid_att_index has gone
Date: Mon, 03 Oct 2005 16:01:02 +0200
Message-ID: <4341399E.3040205@sector-x.de> (raw)
In-Reply-To: <434123CA.2020708@sector-x.de>
References: <20051003110226.GA26883@uio.no>
<434123CA.2020708@sector-x.de>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> 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.
go searching the internet first, man ...
Surprisingly I'm not the first one having such a breakdown
Found a solution provided by Tom Lane:
http://www.xy1.org/pgsql-general@postgresql.org/msg04568.html
Seems to work, many thanks
Sorry for the overhasty question
Harald
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: GnuPT 2.7.2
iQEVAwUBQ0E5nXfX3+fgcdKcAQJWsgf+JvgWRjgl/RLBzGd8wNt7x6/VngGOzdpT
4E3OgbrGuAPEC3INkMLTLRU2hVvjRqgkNaWS2YlXpFmlAff6czGeSbwXv4vDiiH7
AYHpONACLgr8jcHohS0kmylqu/3QYSsmRBDOTOCNms1iMEmJZvpru9YJpSEjwWUL
/n5pu5lurcpU+VGLTCikin5UnsNWmQzsegz+f2co3UuTDHIUER+W2538Fb9iiZBD
P9TCI972U+oC2YTg+Puh22jPfS1gG7EHUxKt/XbE9klca1AnCdJX6LdsIh7vdMhw
6u8JzaaAz9nHtqYFpClkEpnkp9KEohw/uQyDUCB7FK//MRtSWx+MPw==
=52pe
-----END PGP SIGNATURE-----
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: <4341399E.3040205@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