Help | Site Map
Connecting Tech Pros Worldwide
Reply
 
LinkBack Thread Tools
  #1  
Old April 22nd, 2008, 11:50 AM
Member
 
Join Date: Jul 2006
Posts: 47
Default Transaction Isolation Level

Hi everyone!

I´m 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
Reply
  #2  
Old April 22nd, 2008, 12:19 PM
Moderator
 
Join Date: Dec 2006
Posts: 250
Default

Quote:
Originally Posted by zeny
Hi everyone!

I´m 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.
Reply
  #3  
Old April 24th, 2008, 12:30 PM
Member
 
Join Date: Jul 2006
Posts: 47
Default

Quote:
Originally Posted by rski
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.
Reply
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over network members.
Post your question now . . .
It's fast and it's free

Popular Articles