From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: persistent db connections in PHP |
Date: | 2007-06-21 15:32:51 |
Message-ID: | 467A9A23.2020100@g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Raymond O'Donnell wrote:
>
> 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?
I wasn't speaking of pg_pconnect. I was speaking of mysql_connect and
pg_connect.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2007-06-21 15:39:16 | Re: Experiences of PostgreSQL on-disk bitmap index patch |
Previous Message | Germán Hüttemann Arza | 2007-06-21 15:30:53 | Throwing exceptions |