"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