pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (3+ messages)  latest in thread

Message-ID: <426E3057.6010804@leeds.ac.uk>
Permalink:  ../426E3057.6010804@leeds.ac.uk/
Also on:    postgresql.org/message-id/426E3057.6010804@leeds.ac.uk

 · 

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 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