Re: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE on 7.0

> Enrico Mangano writes:
>
> > uidb=# SET TRANSACTION ISOLATION LEVEL SERIALIZABLE ;
> > SET VARIABLE
> > uidb=# SHOW TRANSACTION ISOLATION LEVEL ;
> > NOTICE:  TRANSACTION ISOLATION LEVEL is READ COMMITTED
> > SHOW VARIABLE
> >
> > Has the variable really been setted?
>
> Yes, but if was reset after the transaction finished.  What you're after
> is SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE
> in 7.1.  (Yes, if I had been in charge I would have chosen a more concise
> name.)

Setting session characteristics would set it for session, but
I guess he want to set transaction isolation level for a transaction
in this case??
# begin;
# set transaction isolation level serializable;
# show variable;
NOTICE:  TRANSACTION ISOLATION LEVEL is SERIALIZABLE
SHOW VARIABLE
(Don't forget to set isolation level each transaction that needs serializable
level isolation.)
--
Yasuo Ohgaki