Re: lifetime of temp schema versus compiled image of plpgsql proc

Dennis wrote:
> Bruce Momjian writes: 
> 
> > 
> > There is an FAQ item on this --- use EXECUTE.
> 
> So I should be using EXECUTE for all access to the temp tables? ie inserts, 
> and selects (in this case). Should I use execute for the table creation? 

All access from plpgsql functions for temp tables should use EXECUTE,
yea.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073