Re: Server-side hooks for user session start and session end

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Server-side hooks for user session start and session end
Date: 2015-09-27 11:42:32
Message-ID: CAFj8pRAzFFyXqM0U-c2UrqMtHdpWtRw4UAE0ek+B6T96gHi2Lw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2015-09-27 13:33 GMT+02:00 Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru>:

> Hi,
> 27.09.2015 8:29, Pavel Stehule:
>
>> I'll check it.
>>
>>
>> It is working. Patch attached
>>
>
> Oh, brilliant! This is a _huge_ help actually!
>
> If I understand it correctly, any unhandled SQL-level exceptions will
> essentially be ignored there, so that the session will continue regardless?
>

no, unhandled exeception enforce FATAL error. So you cannot to login to
this session

>
> And maybe it could even be proposed for upstream?
>

It is extension, so it can live outside.

The accepting to upstream depends on community. I have not too free time to
push this patch. But anybody can do it - or upload to PGXN

> It is so wonderfully small and looks not too much intrusive.
>

It is really simple.

Regards

Pavel

>
> Thank you,
> Nikolai
>
>
>> Regards
>>
>> Pavel
>>
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2015-09-27 17:16:14 error on CREATE INDEX when restoring from dump file: could not read block 0
Previous Message Nikolai Zhubr 2015-09-27 11:33:16 Re: Server-side hooks for user session start and session end