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

From lawpoop@gmail.com
Subject Re: persistent db connections in PHP
Date
Msg-id 1182092118.214922.4660@w5g2000hsg.googlegroups.com
Whole thread Raw
In response to Re: persistent db connections in PHP  ("Martin Gainty" <mgainty@hotmail.com>)
Responses Re: persistent db connections in PHP
List pgsql-general
This seems to be a problem with PHP, or at least my set up.

I'm writing pages in basically the same way. Each page has an include
at the top that gets you a database session. The function, either
pg_connect() or mysql_connect(), is supposed to either create a new
connection, or return your existing one.

So after I have a connection, I can navigate to other pages, reload or
post to the current one, trigger the x_connect(), and get the session
I created earlier.

In my Mysql site, if I create temporary tables, I still have access to
them after I have traversed a mysql_connect. So it looks like PHP is
giving me the connection I had when I created the temp tables.

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.

Steve


pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: how to speed up query
Next
From: Tom Lanyon
Date:
Subject: fsync error when restoring from archived xlogs