Re: A bad behavior under autocommit off mode - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 22451.1045756755@sss.pgh.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-hackers
"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> On Thursday 20 February 2003 10:38, Tom Lane wrote:
>> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> There seems a bad behavior under autocommit off mode.
> 
> 1) psql -c 'set autocommit to off;select 1;commit'
> causes a WARNING:  COMMIT: no transaction in progress
>> 
>> Surely that's a bug: the SELECT ought to start a transaction block.

> Sure but doesn't it also commit it?

Not in autocommit-off mode.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: A bad behavior under autocommit off mode
Next
From: "Dave Page"
Date:
Subject: Re: request for sql3 compliance for the update command