Re: cache lookup of relation 165058647 failed - Mailing list pgsql-general

From Juris Krumins
Subject Re: cache lookup of relation 165058647 failed
Date
Msg-id 20040426123152.C61393@juriskr_workstation
Whole thread Raw
In response to Re: cache lookup of relation 165058647 failed  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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
>

pgsql-general by date:

Previous
From: Bruno Baguette
Date:
Subject: Restart increment to 0 each year = re-invent the sequences mecanism ?
Next
From: "Stijn Vanroye"
Date:
Subject: Re: What is wrong here?