From: Oliver Duke-Williams <o.w.duke-williams@leeds.ac.uk>
To: pgsql-admin@postgresql.org
Subject: Unable to drop index
Date: Tue, 26 Apr 2005 13:13:11 +0100
Message-ID: <426E3057.6010804@leeds.ac.uk> (raw)
Hi,
I have an error trying to drop an index using PostgreSQL 7.4.6 running
on Solaris 2.9.
The table on which the index was built is no longer present (it should
have been dropped by my application after being used), but it would
appear that the index was not dropped at the same time as the table:
drop index iext_41827440000_24 ;
ERROR: could not open relation with OID 147483811
Looking in pg_class for an entry with this OID (147483811) returns 0
rows; an entry exists in pg_class for the index itself.
How can I safely remove the index? The old copy of the index is
preventing the creation of a new table and associated index of the same
names.
Would manually deleting the records that relate to the index in pg_index
and pg_class be sufficient, or is that likely to do more harm than good?
Many thanks,
Oliver
--
Oliver Duke-Williams <o.w.duke-williams@leeds.ac.uk>
School of Geography University of Leeds
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: o.w.duke-williams@leeds.ac.uk
Subject: Re: Unable to drop index
In-Reply-To: <426E3057.6010804@leeds.ac.uk>
References: <426E3057.6010804@leeds.ac.uk>
* 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