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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "Lacey, Nathan" <nlacey(at)novetta(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:53:11
Message-ID: CAKFQuwYO=OvMRKBxrXwBSTvqmVzK+UBiEXJfv9xg-GQk0qDxOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Lacey, Nathan 2019-01-15 18:55:15 Re: Postgres 10, changing user by "set role {user};" doesn't use that users "default_transaction_isolation"
Previous Message Tom Lane 2019-01-15 18:42:56 Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT