Re: Cache lookup failed for relation, when trying to DROP TABLE. - Mailing list pgsql-general

From Tom Lane
Subject Re: Cache lookup failed for relation, when trying to DROP TABLE.
Date
Msg-id 26266.1097075430@sss.pgh.pa.us
Whole thread Raw
In response to Cache lookup failed for relation, when trying to DROP TABLE.  (Mark Gibson <gibsonm@cromwell.co.uk>)
Responses Re: Cache lookup failed for relation, when trying to DROP  (Mark Gibson <gibsonm@cromwell.co.uk>)
List pgsql-general
Mark Gibson <gibsonm@cromwell.co.uk> writes:
> I kept getting the following error:
> ERROR:  cache lookup failed for relation 4667548

This implies that something someplace still has a link to the table with
that OID.  You could do "\set VERBOSITY verbose" so that the code
location the error occurs at gets reported; that might be enough
information to guess what sort of thing is linking to the table.
Or you could just dig through the system catalogs looking for 4667548
in an OID column that links to pg_class.

            regards, tom lane

pgsql-general by date:

Previous
From: Mark Gibson
Date:
Subject: Re: Commands to browse current connections and processes
Next
From: Ben
Date:
Subject: database constraints