Re: Referencing columns from system tables possible?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Boris Popov <boris(at)procedium(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Referencing columns from system tables possible?
Date: 2003-11-08 19:37:26
Message-ID: 20031108193726.GB11397@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message elein 2003-11-08 19:38:37 Re: Temp rows - is it possible?
Previous Message Jan Wieck 2003-11-08 19:32:58 Re: int8 primary keys still not using index without manual