X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BA5FD53E11 for ; Tue, 26 Apr 2005 09:13:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71947-08 for ; Tue, 26 Apr 2005 12:13:13 +0000 (GMT) Received: from mta08-winn.mailhost.ntl.com (smtpout16.mailhost.ntl.com [212.250.162.16]) by svr1.postgresql.org (Postfix) with ESMTP id F38745408C for ; Tue, 26 Apr 2005 09:13:10 -0300 (ADT) Received: from aamta06-winn.mailhost.ntl.com ([212.250.162.8]) by mta08-winn.mailhost.ntl.com with ESMTP id <20050426121313.TJQK21532.mta08-winn.mailhost.ntl.com@aamta06-winn.mailhost.ntl.com> for ; Tue, 26 Apr 2005 13:13:13 +0100 Received: from [80.1.105.125] by aamta06-winn.mailhost.ntl.com with ESMTP id <20050426121313.XEDA5678.aamta06-winn.mailhost.ntl.com@[80.1.105.125]> for ; Tue, 26 Apr 2005 13:13:13 +0100 Message-ID: <426E3057.6010804@leeds.ac.uk> Date: Tue, 26 Apr 2005 13:13:11 +0100 From: Oliver Duke-Williams User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Unable to drop index Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/411 X-Sequence-Number: 17424 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 School of Geography University of Leeds