Received: from smtp.noos.fr (camus.noos.net [212.198.2.70]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9DHDjr22260 for ; Sat, 13 Oct 2001 13:13:45 -0400 (EDT) (envelope-from esaracco@noos.fr) Received: (qmail 78647488 invoked by uid 0); 13 Oct 2001 17:13:43 -0000 Received: from unknown (HELO noos.fr) ([212.198.229.109]) (envelope-sender ) by 212.198.2.70 (qmail-ldap-1.03) with SMTP for ; 13 Oct 2001 17:13:43 -0000 Message-ID: <3BC8767C.4080606@noos.fr> Date: Sat, 13 Oct 2001 19:14:36 +0200 From: Emmanuel SARACCO Reply-To: esaracco@noos.fr User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5+) Gecko/20011012 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: temp tables and pg_pconnect() Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/51 X-Sequence-Number: 604 hi, I am using temp tables in stored procedures (I just can not create normal tables because I must retreive values from those tables in those stored procedures with the "execute" instruction). doing connexions with pg_connect()/pg_close() on each php page all work fine, but when I try to use pg_pconnect() (wich is much more efficient!) temp table are not detroyed... how can I use pg_connect() and continue using temp tables in stored procedures? thanks -- Emmanuel SARACCO Email: esaracco@noos.fr