Received: from ford.rutgersinsurance.com ([38.138.71.203]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9DIN6r35101 for ; Sat, 13 Oct 2001 14:23:06 -0400 (EDT) (envelope-from aalang@rutgersinsurance.com) Received: (from root@localhost) by ford.rutgersinsurance.com (8.11.2/8.11.2) id f9DIDj900764 for pgsql-php@postgresql.org.KAV; Sat, 13 Oct 2001 14:13:45 -0400 Received: from nj012 ([10.10.10.51]) by ford.rutgersinsurance.com (8.11.2/8.11.2) with SMTP id f9DIDjq00756 for ; Sat, 13 Oct 2001 14:13:45 -0400 Message-ID: <001201c15414$17c12ea0$330a0a0a@rutgersinsurance.com> From: "Adam Lang" To: References: <3BC8767C.4080606@noos.fr> Subject: Re: temp tables and pg_pconnect() Date: Sat, 13 Oct 2001 14:23:01 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200110/52 X-Sequence-Number: 605 Are temp tables supposed to be destroyed when the connection is cosed? If so, then the reason is because with pconnect, the connection really is never killed as far as Postgresql sees it. The connection remains open. Can you drop the temp table yourself through the pg_exec comand and just use DROP TABLE ? Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Emmanuel SARACCO" To: Sent: Saturday, October 13, 2001 1:14 PM Subject: [PHP] temp tables and pg_pconnect() > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >