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

Поиск
Список
Период
Сортировка
От Lacey, Nathan
Тема Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Дата
Msg-id CAKWhzQaRQByK9BBFcyPe-2MeKWVFSfN3DR8dXiKJacOp661dLg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Список pgsql-bugs
Дерево обсуждения
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.

В списке pgsql-bugs по дате отправления: