From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: A bad behavior under autocommit off mode |
Date: | 2003-03-20 05:05:20 |
Message-ID: | 200303200505.h2K55KO24148@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> 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).
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Vadim Mikheev | 2003-03-20 05:06:17 | Re: Nested transactions: low level stuff |
Previous Message | Bruce Momjian | 2003-03-20 04:56:27 | Re: A bad behavior under autocommit off mode |