You got it backwards I think. He wants to use pg_pconnect and have the temp tables dropped. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Papp Gyozo" <pgerzson@xxxxxxxxxxxx> To: <esaracco@xxxxxxx>; <pgsql-php@xxxxxxxxxxxxxx> Sent: Saturday, October 13, 2001 3:04 PM Subject: Re: [PHP] temp tables and pg_pconnect() > 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" <esaracco@xxxxxxx> > To: <pgsql-php@xxxxxxxxxxxxxx> > 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@xxxxxxx > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 4: Don't 'kill -9' the postmaster > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >
