| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Libsis <libsis(at)arnet(dot)com(dot)ar> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: create/drop table bug |
| Date: | 2004-12-12 01:55:57 |
| Message-ID: | 20041212015557.GA43380@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-12-12 04:13:18 | Re: bug at build_dummy_tuple |
| Previous Message | Michael Fuhr | 2004-12-11 20:04:43 | Re: concat fails 'sometimes' on empty colums in select |