On Wed, 2005-07-06 at 11:20 -0400, Tom Lane wrote:
> 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
>
Tom,
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.
Thanks
Joe
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>