Re: [BUGS] Set Transaction Isolation level bug - Mailing list pgsql-bugs

From Vadim Mikheev
Subject Re: [BUGS] Set Transaction Isolation level bug
Date
Msg-id 37D70901.4C91533F@krs.ru
Whole thread Raw
In response to Re: [BUGS] Set Transaction Isolation level bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Set Transaction Isolation level bug
Next
From: Alois Maier
Date:
Subject: Re: [BUGS] Set Transaction Isolation level bug