On 3 June 2010 19:17, Kevin Kempter <kevink@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
