Received: from pompom.freestart.hu (pompom.freestart.hu [213.197.64.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9DJTFr52853 for ; Sat, 13 Oct 2001 15:29:16 -0400 (EDT) (envelope-from pgerzson@freestart.hu) Received: from erinyes.freestart.hu ([213.197.64.251]) by freestart.hu with esmtp (Freestart relay 1 (FS-Lin)) id 15sTuL-0007dS-00; Sat, 13 Oct 2001 20:53:13 +0200 Received: from line-74-140.dial.freestart.hu ([213.197.74.140] helo=jaguar) by erinyes.freestart.hu with smtp (Exim 3.32 #1 (Debian)) id 15sUCF-0002WM-00; Sat, 13 Oct 2001 21:11:43 +0200 Message-ID: <002b01c15419$d1b4fee0$01fdfea9@jaguar> From: "Papp Gyozo" To: , References: <3BC8767C.4080606@noos.fr> Subject: Re: temp tables and pg_pconnect() Date: Sat, 13 Oct 2001 21:04:00 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanner: exiscan by Freestart X-Archive-Number: 200110/54 X-Sequence-Number: 607 I'm afraid you can't save your temp tables if you use pg_connect, because the connection opened by pg_connect automagically closed on the end of the script. So connection closed and temp tables will be dropped. ----- Original Message ----- From: "Emmanuel SARACCO" To: Sent: Saturday, October 13, 2001 7: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