Обсуждение: Set Transcation Isolation level bug

Поиск
Список
Период
Сортировка

Set Transcation Isolation level bug

От
Alois Maier
Дата:
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 erializable.


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


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com