"Michael Paesold" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
