Re: persistent db connections in PHP - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: persistent db connections in PHP
Date
Msg-id 4679834E.2050701@iol.ie
Whole thread Raw
In response to Re: persistent db connections in PHP  (Scott Marlowe <smarlowe@g2switchworks.com>)
Responses Re: persistent db connections in PHP  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
lawpoop@gmail.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@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: Running OS-level programs from Postgres?
Next
From: Steve Atkins
Date:
Subject: Re: Running OS-level programs from Postgres?