Re: Connection handling of Postgre under PHP - Mailing list pgsql-general

From ljb
Subject Re: Connection handling of Postgre under PHP
Date
Msg-id a6ouo0$1vp2$1@jupiter.hub.org
Whole thread Raw
In response to Connection handling of Postgre under PHP  (stefan_landgraf@gmx.de (Stefan Landgraf))
List pgsql-general
stefan_landgraf@gmx.de wrote:
> Hi group!
>
> When I use pg_pconnect(...) for connecting, is this connection
> exclusively reserved for the actual script or can other scripts
> running parallel use the same connection? I ask because I want to be
> sure that no other process will interfere into running transactions...

You can't do what you want, and it doesn't work the way you think.
Persistent connections gain you nothing in functionality as far as
scripts are concerned - it is purely a (supposed) performance issue.
Please read chapter 22 of the PHP manual, "Persistant Database Connections"
for more on this.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Looking for information about rtree index
Next
From: Fernando Lozano
Date:
Subject: Standby databases