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

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

any clues?

murray