Re: Add read-only param to set_config(...) / SET that effects (at least) customized runtime options

2018-04-27 Thread Chapman Flack
On 04/20/2018 04:18 PM, Chapman Flack wrote: > On 04/20/2018 04:03 PM, Andrew Gierth wrote: >> Assign hooks aren't allowed to throw errors under any circumstance >> because they're called during transaction abort, and throwing an error >> during abort is obviously not tolerable. > > Ah yes, now y

Re: Add read-only param to set_config(...) / SET that effects (at least) customized runtime options

2018-04-20 Thread Chapman Flack
On 04/20/2018 04:03 PM, Andrew Gierth wrote: >> "Chapman" == Chapman Flack writes: > Chapman> It seemed to me at the time to be not hard to implement, even > Chapman> just as an extension for proof of concept. One small obstacle > Chapman> is that the check hook on a variable doesn't get ca

Re: Add read-only param to set_config(...) / SET that effects (at least) customized runtime options

2018-04-20 Thread Andrew Gierth
> "Chapman" == Chapman Flack writes: Chapman> It seemed to me at the time to be not hard to implement, even Chapman> just as an extension for proof of concept. One small obstacle Chapman> is that the check hook on a variable doesn't get called during Chapman> attempted RESET, so the only

Re: Add read-only param to set_config(...) / SET that effects (at least) customized runtime options

2018-04-20 Thread Chapman Flack
On 04/20/2018 09:55 AM, Matthias Kurz wrote: > SET READONLY my_app.some_var = 'foo'; > SET READONLY SESSION my_app.some_var = 'foo'; > SET READONLY LOCAL my_app.some_var = 'foo'; > > Of course read-only would default to false for backwards compatibility. > When setting READONLY for on SESSION con

Add read-only param to set_config(...) / SET that effects (at least) customized runtime options

2018-04-20 Thread Matthias Kurz
Hi, in MS SQL Server you are able to make an entry of SESSION_CONTEXT read-only by passing the @read_only param to the sp_set_session_context function: "[ @read_only= ] { 0 | 1 } A flag of type bit. If 1, then the value for the specified key cannot be changed again on this logical connection. If 0