Re: ERROR: relation with OID XXXX does not exist - Mailing list pgsql-novice

From Tom Lane
Subject Re: ERROR: relation with OID XXXX does not exist
Date
Msg-id 29508.1187413841@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: relation with OID XXXX does not exist  ("David Monarchi" <david.e.monarchi@gmail.com>)
Responses Re: ERROR: relation with OID XXXX does not exist  ("David Monarchi" <david.e.monarchi@gmail.com>)
List pgsql-novice
"David Monarchi" <david.e.monarchi@gmail.com> writes:
> I am executing a function which includes the code fragment shown below.  It
> goes through the loop and then fails with the error message
>      ERROR: relation with OID 591161 does not exist

I think the problem is here:

>   -- drop & recreate table for sorting
>   drop table if exists dom1_classid_sorted_temp;
>   create table dom1_classid_sorted_temp (id_dom integer, class_rank_dom
> serial) without oids;

plpgsql tries to cache plans for its queries, and dropping a table
invalidates any already-made plans for that table.  Can you TRUNCATE
the table instead?

PG 8.3 will be smarter about this sort of thing.

            regards, tom lane

pgsql-novice by date:

Previous
From: "David Monarchi"
Date:
Subject: ERROR: relation with OID XXXX does not exist
Next
From: Christoph Frick
Date:
Subject: Re: large duplicated files