Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1546: Temp table isn't deleted at the end of a - Mailing list pgsql-bugs

From Roy Badami
Subject Re: BUG #1546: Temp table isn't deleted at the end of a
Date
Msg-id 16956.15518.659138.704775@giles.gnomon.org.uk
Whole thread Raw
Responses Re: BUG #1546: Temp table isn't deleted at the end of a  (Roy Badami <roy@gnomon.org.uk>)
List pgsql-bugs
Tree view 
> 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

pgsql-bugs by date:

Previous
From: Roy Badami
Date:
Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,