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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Дата
Msg-id CAKFQuwYO=OvMRKBxrXwBSTvqmVzK+UBiEXJfv9xg-GQk0qDxOA@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"  ("Lacey, Nathan" <nlacey@novetta.com>)
Ответы Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"  ("Lacey, Nathan" <nlacey@novetta.com>)
Список pgsql-bugs
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT
Следующее
От: "Lacey, Nathan"
Дата:
Сообщение: Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"