Hiroshi Inoue <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly