Trouble with creating tempoprary tables in plpgsql - Mailing list pgsql-sql

From Alexander Stetsenko
Subject Trouble with creating tempoprary tables in plpgsql
Date
Msg-id 3940AF67.828BFA6E@anapa.org.ru
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Oliver Graf
Date:
Subject: RE: SQL 'Case When...'
Next
From: Niall Smart
Date:
Subject: Re: Problem with subquery in CHECK constraint.