default isolation level per user?

Hi all;

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

Thanks in advance...

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: default isolation level per user?

On 3 June 2010 19:17, Kevin Kempter 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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin