Re: Referencing columns from system tables possible?

Why not place the pid of the process into your session and set up a cronjob to look at pg_listner and delete any pid's from the session file that have gone away?  Only down side is if you recycle pid's really quickly.

Alvaro Herrera wrote:

On Fri, Nov 07, 2003 at 07:33:47PM -0800, Boris Popov wrote:

Boris,
 

AH> (I don't remember why you rejected the idea of having a cron job to
AH> delete entries belonging to expired sessions ...)

Reason I'm trying to find a different solution is to avoid
implementing application heartbeat that updates the timestamp.   

I don't think there's another way because you'd need the "trigger on
disconnect" or some such that doesn't exist (yet).