Re: default isolation level per user?

On 3 June 2010 19:17, Kevin Kempter <kevink(at)consistentstate(dot)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(at)localhost test=#
show default_transaction_isolation;
default_transaction_isolation
-------------------------------
read committed
(1 row)

postgres(at)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(at)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(dot)ru(at)gmail(dot)com / Skype: gray-hemp / ICQ: 29353802