I'v find out that this error occurs in: dependency.c file 2004-04-26 11:09:34 ERROR: dependency.c 1621: cache lookup of relation 149064743 failed 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist 2004-04-26 11:09:34 ERROR: Relation "tmp_table1" does not exist in getRelationDescription(StringInfo buffer, Oid relid) function. Any ideas what can cause this errors. On Wed, 14 Apr 2004, Tom Lane wrote: > Richard Huxton <dev@archonet.com> writes: > > The error is complaining about a relation that used to have an OID of > > 165058647. This is almost certainly a temporary table. Are there any plpgsql > > functions referring to a temporary table, or do you create, drop, recreate > > tmp_table1 within the same connection? > > The trace suggests this is happening immediately after connect, so the > last part doesn't sound right. It could be a plpgsql function problem, > though the query doesn't look like it invokes any functions. > > What I was wondering about was dangling references within a view, that > is a view referring to a table that no longer exists. (That shouldn't > happen anymore in 7.3 and later, but if this is a pre-7.3 system then > it's possible.) Does this query make use of any views, and if so do the > views change from time to time? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly
