Thread: Get TRANSACTION LEVEL ?

Get TRANSACTION LEVEL ?

From
Alois Maier
Date:
I know that I can set the transaction level with  the
GET TRANSACTION  LEVEL statement.  How can I get the
transaction level using SQL ?
I haven't fount a corresponding get SQL statement in
the 6.5.1 User's guide and GET TRANSACTION LEVEL
didn't work in psql.
Any comments are appreciated.
    Alois

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com

************



************



Re: [GENERAL] Get TRANSACTION LEVEL ?

From
Tatsuo Ishii
Date:
> I know that I can set the transaction level with  the
> GET TRANSACTION  LEVEL statement.  How can I get the
> transaction level using SQL ?
> I haven't fount a corresponding get SQL statement in
> the 6.5.1 User's guide and GET TRANSACTION LEVEL
> didn't work in psql.
> Any comments are appreciated.
>     Alois

show transaction isolation level;
--
Tatsuo Ishii