Thread: Set Transaction Isolation level bug

Set Transaction Isolation level bug

From
Alois Maier
Date:
Your name               :       Alois Maier
Your email address      :       almaier@yahoo.com


System Configuration
---------------------
Architecture (example: Intel Pentium)   :   Intel Pentium
Operating System (example: Linux 2.0.26 ELF)    :   Linux 2.0.36 ELF
PostgreSQL version (example: PostgreSQL-6.5.1):   PostgreSQL-6.5.1
Compiler used (example:  gcc 2.8.0)             :   egcs-2.91.66

Please enter a FULL description of your problem:
------------------------------------------------
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE  does not set the
transaction isolation level to serializable.

------------------------------------------------------------------
Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
test=> SHOW TRANSACTION ISOLATION LEVEL;
NOTICE:  TRANSACTION ISOLATION LEVEL is READ COMMITTED
SHOW VARIABLE
test=> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET VARIABLE
test=> SHOW TRANSACTION ISOLATION LEVEL;
NOTICE:  TRANSACTION ISOLATION LEVEL is READ COMMITTED
SHOW VARIABLE

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