Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation" - Mailing list pgsql-bugs

From Lacey, Nathan
Subject Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Date
Msg-id CAKWhzQZUR2qg=0Do0q_gBa8agKmLqHD_yTGbztJ4GuC4Ps3vbg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT