Thread: Trouble with creating tempoprary tables in plpgsql

Hi
I create some temporary tables in plpgsql function:
"create temp table as select * ..."
all works if I execute this function standalone 
but if this function is called by another function more then once
temp tables can`t be create because ones exists
I was trying bypass this first create temp tables and after insert to
them data
but error arised when I wrote "create temp table( some params );" or
"drop table ..."
Help me please
How can I avoid a need to create static tables
and how can I drop temporary tables If it is possible :-)
Thank you 
--    "The Element"
C  o  m  p  u  t  e  r 
Information & Systems    
Company: http://element.anapa.org.ru