Re: ERROR: relation with OID XXXX does not exist

"David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)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