By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Transaction Isolation Level

P: 44
Hi everyone!

Im using postgreql 8.3 and I know that the default transaction level in postgresql is READ_COMMITED, but how can I check the actual transaction isolation level at any time (in pgadminIII, preferably)?

Regards
Apr 22 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 700
Hi everyone!

Im using postgreql 8.3 and I know that the default transaction level in postgresql is READ_COMMITED, but how can I check the actual transaction isolation level at any time (in pgadminIII, preferably)?

Regards
I do not use PgAdmin, form psql client you can write
Expand|Select|Wrap|Line Numbers
  1.  show transaction isolation level;
  2.  
I believe you can use it also under PgAdmin.
Apr 22 '08 #2

P: 44
I do not use PgAdmin, form psql client you can write
Expand|Select|Wrap|Line Numbers
  1.  show transaction isolation level;
  2.  
I believe you can use it also under PgAdmin.
Thank u very much, it works under PgAdmin alright.
Apr 24 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.