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).
>
>
>