> I bet he's using the temp table without EXECUTE. That
> would've failed even without the other "calling" function
> around it, as soon as he uses it more than once per session.
>
> SPI still needs to learn how to determine if a query uses
> temp tables somewhere in order to silently re-prepare queries
> when required. And I am absolutely sure this is not an issue
> we should address in PL/pgSQL. It has to be solved on the SPI
> level.
Will this still be an issue with schemas? I am thinking no.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026