Thread: Setting Transaction level doesn't work

Hi all,

I've tried to set the transaction isolation level in 6.5 to serializable

with "set transaction isolation level serializable" in psql. A "show
transaction isolation level" tells me that it is still "read commited".
Any Hints ?

Is there a possibility to have transaction level setted to serializable
as default level?

Many thanks in advance

Norbert

This only makes sense if called in a transaction (after begin).

On 2000-01-11, Norbert Meissner mentioned:

> Hi all,
>
> I've tried to set the transaction isolation level in 6.5 to serializable
>
> with "set transaction isolation level serializable" in psql. A "show
> transaction isolation level" tells me that it is still "read commited".
> Any Hints ?
>
> Is there a possibility to have transaction level setted to serializable
> as default level?
>
> Many thanks in advance
>
> Norbert
>
>
>
> ************
>
>

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden