Re: A bad behavior under autocommit off mode - Mailing list pgsql-hackers

From Tom Lane
Subject Re: A bad behavior under autocommit off mode
Date
Msg-id 20360.1048135748@sss.pgh.pa.us
Whole thread Raw
In response to Re: A bad behavior under autocommit off mode  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: A bad behavior under autocommit off mode  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: A bad behavior under autocommit off mode  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: regression failure - horology
Next
From: Neil Conway
Date:
Subject: Re: A bad behavior under autocommit off mode