Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Anyway should 'set autocommit to off;commit' cause
> a warning or an error in the first place ?
IIRC, the SET does *not* start a transaction, so the COMMIT should raise
a warning.
I do not believe that eliminating the warning from COMMIT is a good
idea. If we didn't have that warning in place, we'd have not known that
we had a bug here. (On the other hand, I'm not in favor of making it
a hard error, either.)
regards, tom lane