Re: BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect

From: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect
Date: 2005-03-18 13:58:59
Message-ID: 200503181458.59593.o.siegmar@vitrado.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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!

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2005-03-18 14:45:39 Re: BUG #1546: Temp table isn't deleted at the end of a
Previous Message Stephan Szabo 2005-03-18 13:29:51 Re: BUG #1546: Temp table isn't deleted at the end of a