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

Re: BUG #1546: Temp table isn't deleted at the end of a

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1546: Temp table isn't deleted at the end of a
Date: 2005-03-18 14:45:39
Message-ID: 20050318064510.D65163@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Fri, 18 Mar 2005, Oliver Siegmar wrote:

> On Friday 18 March 2005 14:29, Stephan Szabo wrote:
> > Given the error message, this seems to be the whole plpgsql caches query
> > plans but we don't invalidate those plans when there are schema changes.
>
> I already tried to execute the 'CREATE TEMP TABLE' statement using EXECUTE to
> avoid cache problems - same problem!

You have to EXECUTE the insert as well.


In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-03-18 17:08:35
Subject: Re: Possible temp table bug in PostgreSQL 7.4.7 / 8.0.1
Previous:From: Oliver SiegmarDate: 2005-03-18 13:58:59
Subject: Re: BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect

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