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.
> I found the attached entries in the pg_trigger table, but I'm not quite
> sure how to read them, or what to do about them.
They appear to be triggers for a foreign-key constraint between
pl_inventory_analyzer_files_table and pl02_status_table ... so I guess
the question is what happened to the latter?
regards, tom lane