On Wed, 2005-07-06 at 11:20 -0400, Tom Lane wrote: > Joe Markwardt <joe@xxxxxxxxxxxxx> 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 >
tgrelid | tgname | tgfoid | tgtype | tgenabled | tgisconstraint | tgconstrname | tgconstrrelid | tgdeferrable | tginitdeferred | tgnargs | tgattr | tgargs -----------+--------------------------------+--------+--------+-----------+----------------+--------------+---------------+--------------+----------------+---------+--------+----------------------------------------------------------------------------------------------------------- 438095645 | RI_ConstraintTrigger_438095995 | 1654 | 9 | t | t | $1 | 438095488 | f | f | 6 | | $1\000pl_inventory_analyzer_files_table\000pl02_status_table\000UNSPECIFIED\000status_id\000status_id\000 438095645 | RI_ConstraintTrigger_438095996 | 1655 | 17 | t | t | $1 | 438095488 | f | f | 6 | | $1\000pl_inventory_analyzer_files_table\000pl02_status_table\000UNSPECIFIED\000status_id\000status_id\000 438095645 | RI_ConstraintTrigger_438096079 | 1654 | 9 | t | t | status_id_fk | 438094722 | f | f | 6 | | status_id_fk\000pl02_rfq_table\000pl02_status_table\000UNSPECIFIED\000status_id\000status_id\000 438095645 | RI_ConstraintTrigger_438096080 | 1655 | 17 | t | t | status_id_fk | 438094722 | f | f | 6 | | status_id_fk\000pl02_rfq_table\000pl02_status_table\000UNSPECIFIED\000status_id\000status_id\000 438095645 | RI_ConstraintTrigger_694764779 | 1654 | 9 | t | t | $3 | 694764764 | f | f | 6 | | $3\000pl_batch_search_table\000pl02_status_table\000UNSPECIFIED\000status\000status_id\000 438095645 | RI_ConstraintTrigger_694764780 | 1655 | 17 | t | t | $3 | 694764764 | f | f | 6 | | $3\000pl_batch_search_table\000pl02_status_table\000UNSPECIFIED\000status\000status_id\000 (6 rows)
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
