You might want to have the connection be a "pg_pconnect()" and then use a close() to close the connection.
Ray
-----Original Message-----
From: Chris Ruprecht [mailto:chrup999@yahoo.com]
Sent: Monday, June 25, 2001 1:06 PM
To: p-php
Subject: [PHP] Postgress jobs stick around after they have completed
Hi all,
This is on:
RedHat Linux 7.0
Apache 1.3.20
PHP 4.0.6
PostGreSQL 7.1.2
I run a procedure which does a $conn = pg_connect(...); and later a $res =
pg_close( $conn );
The later returns '1' as a result - not sure if that is good or bad (0 =
false, 1 = true?). However, I have the completed job still hanging around
when I do a ps -ef:
postgres 7493 928 14 13:55 ? 00:00:34 postgres: apache phones
[local]
Where am I going wrong?
Best regards,
Chris
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl