Hiroshi Inoue <[EMAIL PROTECTED]> 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. Barry Lind reported what is probably a closely related issue: http://archives.postgresql.org/pgsql-hackers/2003-01/msg00592.php I haven't gotten around to looking at this, but I suspect postgres.c is doing something inside the per-querytree loop that it should be doing outside it, or vice versa. Or possibly the problem is with the klugy way that we hacked autocommit-off into the xact.c state machine. Do you have time to look at it? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])