Re: ERROR: cache lookup failed for relation 438095645 - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: cache lookup failed for relation 438095645
Date
Msg-id 26644.1120663244@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: cache lookup failed for relation 438095645  (Joe Markwardt <joe@avsupport.com>)
Responses Re: ERROR: cache lookup failed for relation 438095645
List pgsql-general
Joe Markwardt <joe@avsupport.com> writes:
>     I am getting this error "ERROR:  cache lookup failed for relation
> 438095645" when i try to run "drop table
> pl_inventory_analyzer_files_table ;" from psql on the database server.

Look through the system catalogs to see where that OID appears.
pg_index.indexrelid, pg_trigger.tgconstrrelid, pg_depend.objid,
pg_depend.refobjid are likely places.

            regards, tom lane

pgsql-general by date:

Previous
From: "Otto Blomqvist"
Date:
Subject: Re: Custom C function shutdown-signaling
Next
From: Richard Huxton
Date:
Subject: Re: Pl/PgsSQL array