Re: BUG #3229: Incorrect temp table work

ALEXEY PARSHIN wrote:
> The following bug has been logged online:
>
> Bug reference:      3229
> Logged by:          ALEXEY PARSHIN
> Email address:      alexeyp@gmail.com
> PostgreSQL version: 8.1.8
> Operating system:   Gentoo Linux
> Description:        Incorrect temp table work
> Details:
>
> If I call the following function two or more time, I get an error "relation
> with OID 318730 does not exist":

this is documented (and a workaround is mentioned as well) in the FAQ:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

and this will get improved (through plan invalidation) in the upcoming
8.3 release of postgresql too in a way that will not require the EXECUTE
workaround any more.


Stefan