Re: Temp rows - is it possible? - Mailing list pgsql-general

From Boris Popov
Subject Re: Temp rows - is it possible?
Date
Msg-id 160366638618.20031107150805@procedium.com
Whole thread Raw
In response to Re: Temp rows - is it possible?  (Ben <bench@silentmedia.com>)
List pgsql-general
Hello Ben,

Friday, November 7, 2003, 2:53:09 PM, you wrote:

B> If the table doesn't have to be 100% accurate, you could always timestamp
B> the rows and have connected clients update their row, while old rows get
B> reaped periodicaly.

I was hoping for a more natural solution. Implementing a heartbeat in
the application is a complication I'd like to avoid at all cost.

-Boris

B> On Fri, 7 Nov 2003, Boris Popov wrote:

>> I do want them to be visible to everybody. This is a sessions pool,
>> where sessions are inserted when our app connects and removed when it
>> disconnects, however this would only work for graceful disconnects,
>> which we all know isn't always the case. So I want a table that is
>> somehow notified of a session disconnect and deletes rows created by
>> that session.
>>
>> Any ideas?



pgsql-general by date:

Previous
From: "David Busby"
Date:
Subject: Re: [ADMIN] [HACKERS] retrieve statement from catalogs
Next
From: sgupta5@ncsu.edu
Date:
Subject: regarding constant values