On Fri, Dec 10, 2004 at 05:30:14PM -0300, Libsis wrote: > ERROR: relation with OID 17687 does not exist > CONTEXT: PL/pgSQL function "myfunc" line 5 at for over select rows > > the oid 17687 is corresponding with the table created inside the > function (SELECT INTO newtable) (see point 3) but later, in the same > function, this table is dropped. when the function (point 5) is > executed again, this search for the oid's table but never found it.
Cached plans are causing the problem. See the PL/pgSQL chapter in the documentation -- the Overview section describes what's happening and how to work around it. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
