alis=# select * from pg_depend where objid in ( 463558, 463559 ) or refobjid
in ( 463558, 463559 );
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+--------+----------+------------+----------+-------------+--------
-
1247 | 463559 | 0 | 1259 | 463558 | 0 | i
1259 | 463558 | 0 | 16672 | 440012 | 0 | n
(2 rows)
alis=# select oid, * from pg_namespace where nspname = 'pg_temp_4';
oid | nspname | nspowner | nspacl
--------+-----------+----------+--------
440012 | pg_temp_4 | 1 |
(1 row)
alis=# select * from pg_depend where refobjid = 440012;
classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
---------+--------+----------+------------+----------+-------------+--------
-
1259 | 463558 | 0 | 16672 | 440012 | 0 | n
----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick.fiche@xxxxxxxxxxx
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------
-----Original Message-----
From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx]
Sent: lundi 23 mai 2005 16:08
To: Patrick.FICHE@xxxxxxxxxxx
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: How to recover from : "Cache lookup failed for
rela tion "
Patrick.FICHE@xxxxxxxxxxx writes:
> The error happens when I try to create other temporary tables.
> Here is a part of my Server Log :
> ERROR: cache lookup failed for relation 463558
> CONTEXT: SQL statement "CREATE TEMP TABLE Tmp_MsgRxOrder ( EventId int4,
> CodeRef int4 )"
> PL/pgSQL function "adm_ne" line 248 at SQL statement
> STATEMENT: SELECT ALIS.ADM_NE()
This must be happening when you first try to use the pg_temp_4 schema
inside a particular session. The code will try to remove the existing
schema contents (as indicated by pg_depend), and evidently there is
something inconsistent in that.
What rows do you have in pg_depend that have either objid or refobjid
equal to 463558 or 463559? Also, get the OID of the pg_temp_4 schema
from pg_namespace, and see what rows in pg_depend have refobjid equal
to that.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
