Bruce said he and Rasmus (from PHP devel) were fixing this. That'll be
great!
-Mitch
----- Original Message -----
From: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
To: <pgsql-hackers@postgresql.org>
Sent: Monday, February 05, 2001 8:55 PM
Subject: RE: Re: PostgreSQL -> PHP problem
> I tell you what I'd like to see in PHP. If you're using a Postgres
> persistent connection, and it detects a 'BEGIN TRANSACTION' going thru,
once
> that script has finished, the connection should not be returned to the
> connection pool.
>
> Chris
>
> > -----Original Message-----
> > From: pgsql-hackers-owner@postgresql.org
> > [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Mitch Vincent
> > Sent: Tuesday, February 06, 2001 2:29 AM
> > To: pgsql-hackers@postgresql.org
> > Subject: [HACKERS] Re: PostgreSQL -> PHP problem
> >
> >
> > In the PHP bugs I see...
> >
> >
> > > > ===============================================[PostgreSQL
> > >related]===========
> > > > 5862 Open Consecutive pg_open statements cause second
> > statement to
> > >fail
> > > > 6525 Open Connection problem
> > > > 7007 Open The pg_close function doesn't close the connection.
> > > > 7236 Open 1 is not a valid PostgreSQL link resource
> > > > 7264 Open 1 is not a valid PostgreSQL link
> > > > 7298 Open ... not a valid link resource... after pg_connect
> > > > 7312 Open Problems with pg_connect() i pg_fetch_row()
> > > > 7333 Open Connection fault in circled query
> > > > 7529 Open pg_connect() returns invalid connection id
> > > > 7536 Open Warning: is not a valid PostgreSQL link resource
xxxx
> > > > 7931 Feedback Undefined symbol "_PQconnectdb"
> > > > 8053 Open PGSQL doesn't detects on FBSD4
> > > > 8225 Open Suddenly doesnt allow multiple psql
> > connections from one
> > >php page
> > > > 8317 Open postgresql table uppercase field name
> > > > 8689 Open pg_Connect() seems to do some type of caching that
> > doesn't
> > >quite work
> > > > 8769 Open Persistent connections aren't closed when using
> > >dynamically loaded module
> > > > 8907 Open pg_Close on multiple connections to same host
> > > > 9048 Open problem to open several connections on 4.0.4pl1 that
> > >worked on 4.0.2
> >
> > Ouch. It looks like this is exactly what is happening to me. pg_open
gets
> > called several times in these scripts.. It looks like I'll have to
install
> > an old version of PHP.. Son of a.... er nevermind..
> >
> > Thanks guys..
> >
> > -Mitch
> >
> >
>
>
