Re: [HACKERS] cache lookup failed in plpgsql - reason?

2012-03-21 Thread Robert Haas
On Wed, Oct 26, 2011 at 10:37 AM, Pavel Stehule pavel.steh...@gmail.com wrote: Oct 25 20:13:44  db-s-01 postgres: local5.warning -- postgres[29970]: [3-1] 2011-10-25 20:13:44 CEST adifd 29970 ERROR:  cache lookup failed for relation 319883311 Oct 25 20:13:44  db-s-01 postgres: local5.warning

[HACKERS] cache lookup failed in plpgsql - reason?

2011-10-26 Thread Pavel Stehule
Hello one my customer reported a random issue. He uses a procedure with following fragment IF NOT EXISTS( SELECT relname FROM pg_class WHERE relname = 'tmp_object_state_change' AND relkind = 'r' AND pg_table_is_visible(oid) ) THEN CREATE TEMPORARY TABLE tmp_object_state_change (