Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliver Siegmar
Subject Re: BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect
Date
Msg-id 200503181458.59593.o.siegmar@vitrado.de
Whole thread Raw
In response to Re: BUG #1546: Temp table isn't deleted at the end of a  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
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!

pgsql-bugs by date:

Previous
From: "Brian O'Reilly"
Date:
Subject: BUG #1552: massive performance hit between 7.4 and 8.0.1
Next
From: Alvaro Herrera
Date:
Subject: Re: pl/pgsql doesn't load