Обсуждение: 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"

От

"Lacey, Nathan"

Дата:

15 января 2019 г., 16:44:06

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"

От

"David G. Johnston"

Дата:

15 января 2019 г., 18:53:11

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"

От

"Lacey, Nathan"

Дата:

15 января 2019 г., 18:55:15

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.

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: 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"

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

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