Re: Postgress jobs stick around after they have completed - Mailing list pgsql-php

From Hunter, Ray
Subject Re: Postgress jobs stick around after they have completed
Date
Msg-id 59358A738F45D51186A30008C74CE2500A07B1@slc-exc1.ctron.com
Whole thread Raw
In response to Postgress jobs stick around after they have completed  ("Chris Ruprecht" <chrup999@yahoo.com>)
List pgsql-php

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

pgsql-php by date:

Previous
From: Chris Ryan
Date:
Subject: Re: Variable question...
Next
From: "Heather Johnson"
Date:
Subject: Re: Re: how to determine where a select statement fails