Re: Postgres 10, changing user by "set role {user};" doesn't use that users "default_transaction_isolation"

From: "Lacey, Nathan" <nlacey(at)novetta(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Postgres Bug <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Postgres 10, changing user by "set role {user};" doesn't use that users "default_transaction_isolation"
Date: 2019-01-15 18:55:15
Message-ID: CAKWhzQZUR2qg=0Do0q_gBa8agKmLqHD_yTGbztJ4GuC4Ps3vbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

ok, thanks
sorry for wasting your time.

On Tue, Jan 15, 2019 at 1:53 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tue, Jan 15, 2019 at 11:49 AM Lacey, Nathan <nlacey(at)novetta(dot)com> wrote:
> > ALTER USER {user} SET default_transaction_isolation TO 'repeatable read';
>
> "SET ROLE does not process session variables as specified by the
> role's ALTER ROLE settings; this only happens during login."
>
> https://www.postgresql.org/docs/11/sql-set-role.html
>
> David J.
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2019-01-15 19:35:32 Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT
Previous Message David G. Johnston 2019-01-15 18:53:11 Re: Postgres 10, changing user by "set role {user};" doesn't use that users "default_transaction_isolation"