Re: A bad behavior under autocommit off mode

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: A bad behavior under autocommit off mode
Дата
Msg-id 20360.1048135748@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 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>)
Re: A bad behavior under autocommit off mode  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: regression failure - horology
Следующее
От: Neil Conway
Дата:
Сообщение: Re: A bad behavior under autocommit off mode