pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddefault isolation level per user?
2+ messages / 2 participants
[nested] [flat]
* default isolation level per user?
@ 2010-06-03 15:17 Kevin Kempter <kevink@consistentstate.com>
0 siblings, 1 reply; 2+ messages in thread
From: Kevin Kempter @ 2010-06-03 15:17 UTC (permalink / raw)
To: pgsql-admin
Hi all;
is it possible to specify a default isolation level for a user/role ?
Thanks in advance...
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: default isolation level per user?
@ 2010-06-03 15:40 Sergey Konoplev <gray.ru@gmail.com>
parent: Kevin Kempter <kevink@consistentstate.com>
0 siblings, 0 replies; 2+ messages in thread
From: Sergey Konoplev @ 2010-06-03 15:40 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-06-03 15:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-03 15:17 default isolation level per user? Kevin Kempter <kevink@consistentstate.com>
2010-06-03 15:40 ` Sergey Konoplev <gray.ru@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox