Re: [GENERAL] persistent db connections in PHP

2007-06-21 Thread Scott Marlowe
Raymond O'Donnell wrote: [EMAIL PROTECTED] 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

Re: [GENERAL] persistent db connections in PHP

2007-06-20 Thread Raymond O'Donnell
[EMAIL PROTECTED] 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

Re: [GENERAL] persistent db connections in PHP

2007-06-20 Thread Scott Marlowe
[EMAIL PROTECTED] wrote: 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 connect

Re: [GENERAL] persistent db connections in PHP

2007-06-18 Thread lawpoop
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 existin

Re: [GENERAL] persistent db connections in PHP

2007-06-16 Thread PFC
Hello all! I'm working on a PHP site using Postgres as a back-end. I have an include at the top of each page that runs the pg_connect function. I'm implementing some temporary tables, which I understand are destroyed automatically at the end of the session. It seems to me that - Temp t

Re: [GENERAL] persistent db connections in PHP

2007-06-16 Thread Martin Gainty
At least in mySQL Any temporary tables are known only t the connection that you have created e.g. /*connected as root to localhost */ mysql> CREATE TEMPORARY TABLE test.TEMP_TABLE (COL VARCHAR(20)); ERROR 1050 (42S01): Table 'temp_table' already exists mysql> SELECT * from test.TEMP_