Re: A bad behavior under autocommit off mode

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> The fix only changes the 'make it all one transaction' behavior. It
> does not effect sending multiple queries in a string ---

Yes it does! The results may change. Also the behavior if later
commands in the string fail will be different (roll back earlier
commands vs not).

> But I do think the roll-queries-into-one-transaction is
> strange and should be removed with the patch.

I disagree. This is long-established behavior and no one has complained
about it. We have gone out of our way to preserve it in past changes;
I don't like suddenly deciding that backwards compatibility is
unimportant. Especially not if only one person is in favor of the change.

regards, tom lane