Re: [HACKERS] proposal: session server side variables (fwd)

On Thu, Jan  5, 2017 at 11:45:24AM +0100, Fabien COELHO wrote:
> 
> <Argh, wrong sender again, sorry [again] for the repost.
>  I must tweak my mail client configuration...>
> 
> >>>Good. So we seem to agree that GUCS are transactional?
> >
> >I'm surprised, I never knew this.
> 
> I must admit that it was also a (good) surprise for me.
> 
> The documentation says it:
> 
> """
> If SET (or equivalently SET SESSION) is issued within a transaction that is
> later aborted, the effects of the SET command disappear when the transaction
> is rolled back. Once the surrounding transaction is committed, the effects
> will persist until the end of the session, unless overridden by another SET.
> """
> 
> But I have not found anything clear about user-defined parameters.

Uh, I think it is a missing feature, i.e.:
https://wiki.postgresql.org/wiki/Todo#AdministrationHave custom variables be transaction-safe 
https://www.postgresql.org/message-id/4B577E9F.8000505@dunslane.net

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +