On 5 January 2017 at 08:35, Craig Ringer <craig@2ndquadrant.com> wrote:
> On 5 January 2017 at 01:49, Fabien COELHO <coelho@cri.ensmp.fr> wrote:
>>
>>> ok understand
>>
>>
>> Good. So we seem to agree that GUCS are transactional?
>
> No. We don't agree. They aren't.
Uh. I take that back.
craig=> SET x.s = 'x';
SET
craig=> BEGIN;
BEGIN
craig=> SET x.s = 'y';
SET
craig=> ROLLBACK;
ROLLBACK
craig=> SHOW x.s;x.s
-----x
(1 row)
I'm surprised, I never knew this.
-- Craig Ringer http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services