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

From: "Lacey, Nathan" <nlacey(at)novetta(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Postgres 10, changing user by "set role {user};" doesn't use that users "default_transaction_isolation"
Date: 2019-01-15 16:44:06
Message-ID: CAKWhzQaRQByK9BBFcyPe-2MeKWVFSfN3DR8dXiKJacOp661dLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2019-01-15 18:24:57 Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT
Previous Message Magnus Hagander 2019-01-15 09:37:00 Re: BUG #15593: Unable to install PostgreSQL