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

From Richard Huxton
Subject Re: cache lookup of relation 165058647 failed
Date
Msg-id 200404141258.20763.dev@archonet.com
Whole thread Raw
In response to cache lookup of relation 165058647 failed  (Juris Krumins <juriskr@komin.lv>)
Responses Re: cache lookup of relation 165058647 failed
Re: cache lookup of relation 165058647 failed
List pgsql-general
On Wednesday 14 April 2004 10:35, Juris Krumins wrote:

> 2004-04-14 12:24:54 [74021]  LOG:  query: SELECT d.config_id, d.text1 as
> text, d.field_name,
> 2004-04-14 12:24:54 [74021]  LOG:  duration: 0.005295 sec
> 2004-04-14 12:24:54 [74021]  LOG:  query: CREATE TEMP TABLE tmp_table1 AS
> SELECT  advert.id, (SELECT employer.fullname FROM employer WHERE
> advert.empid=employer.id) as emp_name, (CASE WHEN advert.status1 = 'A'
> THEN advert.postname1 ELSE advert.postname2 END) as postname, (SELECT
> cd.name FROM catalog_names cd WHERE advert.industry=cd.catalog_id AND
> cd.language_id=1) AS f1002, (CASE WHEN status1='A' THEN
> advert.obligations1 ELSE advert.obligations2 END) as obligations1 FROM
> good_adv as advert
> 2004-04-14 12:24:54 [74021]  ERROR:  cache lookup of relation 165058647
> failed

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?

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: performance problem aftrer update from 7.1 to 7.4.2
Next
From: Juris Krumins
Date:
Subject: Re: cache lookup of relation 165058647 failed