On 3 June 2010 19:17, Kevin Kempter <[email protected]> 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". postg...@localhost test=# show default_transaction_isolation; default_transaction_isolation ------------------------------- read committed (1 row) postg...@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". t...@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: [email protected] / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
