On Wed, 2005-07-06 at 11:20 -0400, Tom Lane wrote:
> 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.
> 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
