Skip site navigation (1) Skip section navigation (2)

Re: Autocommit off and transaction isolation level

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael Paesold" <mpaesold(at)gmx(dot)at>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Autocommit off and transaction isolation level
Date: 2003-01-02 14:33:20
Message-ID: 19946.1041518000@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"Michael Paesold" <mpaesold(at)gmx(dot)at> writes:
> Now setting autocommit=off the set transaction isolation level command does
> not show any effect:

> billing=# set autocommit to off;
> SET
> billing=# set transaction isolation level serializable;
> SET

SET does not start a transaction block, so this will not work.  You must
use an explicit BEGIN before setting TRANSACTION ISOLATION LEVEL.

You might instead set default_transaction_isolation to get the behavior
I think you are looking for.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Justin CliftDate: 2003-01-02 14:59:23
Subject: Re: PostgreSQL Password Cracker
Previous:From: Tom LaneDate: 2003-01-02 14:29:39
Subject: Re: pg_dump.options.diff

pgsql-patches by date

Next:From: Stephan SzaboDate: 2003-01-02 15:39:02
Subject: Re: Autocommit off and transaction isolation level
Previous:From: Tom LaneDate: 2003-01-02 14:29:39
Subject: Re: pg_dump.options.diff

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group