Re: Server-side hooks for user session start and session end - Mailing list pgsql-general

From David G. Johnston
Subject Re: Server-side hooks for user session start and session end
Date
Msg-id CAKFQuwaBaJbXUAWwQCRgquKaejGe1nEG-AwykKP_pSfp9pD+aA@mail.gmail.com
Whole thread Raw
In response to Re: Server-side hooks for user session start and session end  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Saturday, September 26, 2015, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 2015-09-26 19:53 GMT+02:00 Nikolai Zhubr <n-a-zhubr@yandex.ru>:
>> And the events of session start and session end would seem quite generic
>> and usefull anyway?

> I don't know. I am pretty sceptical - from my experience this request was
> related to unhappy designed projects.

A session-end hook seems pretty problematic to me: you simply cannot
guarantee that it will run at all.  (Consider process crash or server
abort cases.)  So anything built on the assumption that it gets to run
at session end is going to be inherently unreliable.


Or even "reset session" as is often used by connection poolers depending on what semantics are trying to be captured.

David J. 

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Server-side hooks for user session start and session end
Next
From: Nikolai Zhubr
Date:
Subject: Re: Server-side hooks for user session start and session end