Re: A bad behavior under autocommit off mode

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

Right, people are using it, but do they even know that those are all one
transaction?  I bet most don't.

> > 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.

I asked for some votes.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Vadim Mikheev"
Дата:
Сообщение: Re: Nested transactions: low level stuff
Следующее
От: Tom Lane
Дата:
Сообщение: Re: A bad behavior under autocommit off mode