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

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

From: Roy Badami <roy(at)gnomon(dot)org(dot)uk>
To: sszabo(at)megazone(dot)bigpanda(dot)com
Cc: o(dot)siegmar(at)vitrado(dot)de, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1546: Temp table isn't deleted at the end of a
Date: 2005-03-19 14:52:14
Message-ID: 16956.15518.659138.704775@giles.gnomon.org.uk (view raw or flat)
Thread:
Lists: pgsql-bugs
> 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.  In all currently released versions you pretty much need to
> use EXECUTE on any queries where the table may go away, for example,
> any use of temp tables.

FWIW, this is documented behaviour (section 35.1 of the manual).

	 -roy

Responses

pgsql-bugs by date

Next:From: Roy BadamiDate: 2005-03-19 14:58:13
Subject: Re: BUG #1546: Temp table isn't deleted at the end of a
Previous:From: Roy BadamiDate: 2005-03-19 14:24:17
Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,

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