Re: proposal: session server side variables

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com>, Joe Conway <mail(at)joeconway(dot)com>
Subject: Re: proposal: session server side variables
Date: 2017-01-02 15:55:49
Message-ID: alpine.DEB.2.20.1701021646570.26374@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello,

>>> In my proposal was support for transaction scope - ON COMMIT RESET
>>> clause should be ok
>>
>> Could you update the wiki, both the proposal and the use-case
>> implementation, to reflect this point?
>>
>> Moreover, is there any actual use-case for non-transactional secure
>> half-persistent session variables? AFAICS the "secure" part implies both
>> permissions and transactional for the presented security-related use case.
>> If there is no use case for these combined features, then ISTM that you
>> should update to proposal so that the variables are always transactional,
>> which is both simpler, more consistent, and I think more acceptable.
>
> If you are transaction sensitive, then you have to be sensitive to
> subtransactions - then the work is much more complex.

Maybe, probably, I do not really know. For now, I'm trying to determine
how the proposals fits Craig's use case.

The current status is that both proposals are useless because the use case
needs "some" transactional property for security. But probably some
improvements are possible.

> Is there use case, when you would to play with transactions and variables
> and RESET is not enough?

I do not know. If you explain more clearly what is meant by a "RESET" on a
variable when the transaction fails, then maybe I can have an opinion.
Currently I'm just guessing in the dark the precise intended semantics.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2017-01-02 17:13:28 Re: Odd behavior with PG_TRY
Previous Message Fabien COELHO 2017-01-02 15:32:47 Re: proposal: session server side variables