Thread: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
From
"Lacey, Nathan"
Date:
Steps to duplicate
ALTER USER {user} SET default_transaction_isolation TO 'repeatable read';
psql -U {user}
SHOW default_transaction_isolation;
with correctly show 'repeatable read'
psql (default with postgres)
set role {user};
SHOW default_transaction_isolation;
will incorrectly show postgres's value?
'read committed'
Thanks for the Awesome work.
Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
From
"David G. Johnston"
Date:
On Tue, Jan 15, 2019 at 11:49 AM Lacey, Nathan <nlacey@novetta.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.
Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
From
"Lacey, Nathan"
Date:
ok, thanks
sorry for wasting your time.
On Tue, Jan 15, 2019 at 1:53 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Jan 15, 2019 at 11:49 AM Lacey, Nathan <nlacey@novetta.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.