Received: from ns.anapa.org.ru (ros-kurort.anapa.krintel.ru [195.161.40.218]) by hub.org (8.10.1/8.10.1) with SMTP id e598nMT12724 for ; Fri, 9 Jun 2000 04:49:23 -0400 (EDT) Received: (qmail 7394 invoked from network); 9 Jun 2000 08:48:39 -0000 Received: from xgate.xnet.ru (HELO anapa.org.ru) (192.168.1.2) by xgate.xnet.ru with SMTP; 9 Jun 2000 08:48:39 -0000 Message-ID: <3940AF67.828BFA6E@anapa.org.ru> Date: Fri, 09 Jun 2000 12:48:39 +0400 From: Alexander Stetsenko Organization: "Element" Computer Information & Systems X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.15 i586) X-Accept-Language: ru, en MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Trouble with creating tempoprary tables in plpgsql Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/101 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