Обсуждение: default isolation level per user?

Hi all;

is it possible to specify a default isolation level for a user/role ?

Thanks in advance...

On 3 June 2010 19:17, Kevin Kempter <kevink@consistentstate.com> wrote:
> is it possible to specify a default isolation level for a user/role ?

It is. At least for 8.4.

\c test postgres localhost 5432
psql (8.4.2)
You are now connected to database "test" at port "5432" as user "postgres".

postgres@localhost test=#
show default_transaction_isolation;
 default_transaction_isolation
-------------------------------
 read committed
(1 row)

postgres@localhost test=#
alter user test set default_transaction_isolation to serializable;
ALTER ROLE

\c - test
psql (8.4.2)
You are now connected to database "test" as user "test".

test@localhost ~=>
show default_transaction_isolation;
 default_transaction_isolation
-------------------------------
 serializable
(1 row)


--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802