Postgres Pro
Downloads
Home   >   mailing lists

Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation" - Mailing list pgsql-bugs

From Lacey, Nathan
Subject Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"
Date
Msg-id CAKWhzQaRQByK9BBFcyPe-2MeKWVFSfN3DR8dXiKJacOp661dLg@mail.gmail.com
Whole thread Raw
Responses Re: Postgres 10, changing user by "set role {user};" doesn't use thatusers "default_transaction_isolation"  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #15593: Unable to install PostgreSQL
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT