Re: ERROR: relation with OID XXXX does not exist

["David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>]

Thanks, Tom.  I'll look forward to 8.3.

If I understand correctly, TRUNCATE is equivalent to DELETE FROM.  My problem was that I also needed to reset the serial attribute.  My solution was the following

  -- clear and reset counter
  delete from dom1_classid_sorted_temp;
  perform setval('dom1_classid_sorted_temp_class_rank_dom_seq'::regclass,1,false);


Thanks again.

Best,
david

On 8/17/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

"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