Re: Postgress jobs stick around after they have completed

on 06/25/2001 23:09, Jason k Larson at jlarson(at)techpilots(dot)net wrote:

> Hello -
>
> Your result of 1 means the close was (supposedly) successful. Not
> sure why you have processes still running though. I would certainly
> expect this pg_pconnect .. are you certain that nowhere else in the
> script is attempting persistent connections? Or was using persistent
> connections .. when in doubt .. try restarting Apache (apachectl
> restart) and see if this process goes away (as it should if PHP
> launched it, etc.)

Ok - I found the bug - I did a pg_pconnect(...). After I changed that to a
pg_connect, the session terminated upon pg_close( ... ).

Since I have not quite been able to locate any docs on PHP-PG connections
and their commands - why would I use a persistent connection? What can I do
with it? Will it stay open until - when?

Thanks for your help guys!!
Chris

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com