AuditInte ( InteRef int4 NOT
NULL, InteRefParent int4 NOT NULL, DynamicFlag int4 NOT NULL DEFAULT (0),
SessionFlag int4 NOT NULL DEFAULT (0), InteStatus varchar(10) NULL,
MinInteNeState int4 NULL, MaxInteNeState int4 NULL, MinSessionNeState int4
NULL, MaxSessionNeState int4 NULL, InteStart timestamp
[EMAIL PROTECTED] writes:
> Do you have any idea on the reason of this situation ?
No, I was hoping we might see some clues but there wasn't much. Both
the pg_depend entries and the pg_type row should have been deleted by
the same transaction that deleted the pg_class row. Partially applied
tran
PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to recover from : "Cache lookup failed for
rela tion "
[EMAIL PROTECTED] writes:
> classid | objid | objsubid | refclassid | refobjid | refobjsu
[EMAIL PROTECTED] writes:
> classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
> -++--++--+-+
> -
> 1247 | 463559 |0 | 1259 | 463558 | 0 | i
> 1259 | 463558 |0 |
ne [mailto:[EMAIL PROTECTED]
Sent: lundi 23 mai 2005 16:08
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to recover from : "Cache lookup failed for
rela tion "
[EMAIL PROTECTED] writes:
> The error happens when I try to create other temporary tables.
[EMAIL PROTECTED] 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
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
S
