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 e57EMnW93929 for ; Wed, 7 Jun 2000 10:22:54 -0400 (EDT) Received: (qmail 27167 invoked from network); 7 Jun 2000 14:21:48 -0000 Received: from ns.anapa.org.ru (195.161.40.218) by ns.anapa.org.ru with SMTP; 7 Jun 2000 14:21:48 -0000 Message-ID: <393E5A7C.7966896B@ns.anapa.org.ru> Date: Wed, 07 Jun 2000 18:21:48 +0400 From: Dmitriy Yusupov 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: pgsql-sql@postgresql.org Subject: Temp table and loop call from one session Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/69 Hi all! I try to do: PL function 1 loop: call PL function 2 PL function 2 create temp table ... ... drop temp table But drop can't work in one session! It's documented. The method with create-drop temp table is most efficient for my problem. What can I do? Any idea? Dmitriy