Joe Markwardt <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to