> 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).
pgsql-bugs by date
|Next:||From: Roy Badami||Date: 2005-03-19 14:58:13|
|Subject: Re: BUG #1546: Temp table isn't deleted at the end of a|
|Previous:||From: Roy Badami||Date: 2005-03-19 14:24:17|
|Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser, |