"Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> writes:
> The simplest way seems to accept COMMIT any time under autocommit
> off mode.
That's just hiding the most visible symptom. The real problem here is
that the SELECT is already committed, when it shouldn't be.
regards, tom lane