RE: Postgress jobs stick around after they have completed

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(at)yahoo(dot)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