Skip site navigation (1) Skip section navigation (2)

Re: create/drop table bug

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 (view raw or flat)
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/

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-12-12 04:13:18
Subject: Re: bug at build_dummy_tuple
Previous:From: Michael FuhrDate: 2004-12-11 20:04:43
Subject: Re: concat fails 'sometimes' on empty colums in select

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group