Re: Autocommit off and transaction isolation level

"Michael Paesold" <mpaesold@gmx.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