Re: [HACKERS] proposal: session server side variables - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] proposal: session server side variables
Date
Msg-id CAFj8pRBNvWSdo24R5i30CLGV0XCi3=ZRizXtKDH+TkmZEmEiOg@mail.gmail.com
Whole thread Raw
In response to proposal: session server side variables  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers


2017-01-05 10:59 GMT+01:00 Fabien COELHO <fabien.coelho@mines-paristech.fr>:

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.


Pavel
 


--
Fabien.

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] proposal: session server side variables
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] Odd behavior with PG_TRY