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
