ALEXEY PARSHIN wrote: > The following bug has been logged online: > > Bug reference: 3229 > Logged by: ALEXEY PARSHIN > Email address: [EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate