Re: temporary tables, plpgsql and yes i bet this has been asked - Mailing list pgsql-sql

Murray Prior Hobbs wrote:
> 
> in a plpgsql function
> 
>     create temporary table X
> 
>     ....
> 
> 
>     drop table X
> 
> 
> then in another function
> 
>     loop
> 
>         call the other function
> 
>     end loop
>    
> 
> i get the problem that the second time the table is created (ie in the 
> second call) it is not visible
> 
> now yes i could declare the table in the calling funtion but then the 
> original function is less useful to me

Interesting.  Can you recreate the problem in psql without the functions
and show an example?  I am confused how this could be failing.

--  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