Re: temporary tables, plpgsql and yes i bet this has been asked

>     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