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

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