Re: persistent db connections in PHP

lawpoop(at)gmail(dot)com wrote:
> However, with this new Postgres site, I don't have access to my temp
> tables after I've traversed another pg_connect. So PHP is either
> creating a new connection, or giving me another session, not the one
> which I created my tables in.

You wouldn't expect to be given back the same connection (and hence the
same temp tables) from a pool of connections - they're returned randomly.

Scott Marlowe wrote:
> MySQL reuses old connections within the same script. PostgreSQL's php
> extension does not, it starts a new connection each time.

Isn't pg_pconnect supposed to recycle a pooled connection?

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------