Horton

Re: [BUGS] Set Transaction Isolation level bug

Vadim Mikheev <vadim@krs.ru>

View thread
From: Vadim Mikheev <vadim@krs.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alois Maier <almaier@yahoo.com>, pgsql-bugs@postgreSQL.org
Date: 1999-09-09T01:10:25Z
Lists: pgsql-bugs 
Tom Lane wrote:
> 
> My own inclination is to think that if SET TRANSACTION ISOLATION LEVEL
> is executed *inside* a BEGIN block, then it should set the IsoLevel for
> that transaction block only, but if executed as a freestanding
> transaction then it ought to set the default IsoLevel for subsequent
                                                            ^^^^^^^^^^
> transactions.  Comments?
  ^^^^^^^^^^^^

My thoughts were to use ALTER SESSION for this.

Vadim