Re: Consider pipeline implicit transaction as a transaction block

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Anthonin Bonnefoy <anthonin(dot)bonnefoy(at)datadoghq(dot)com>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Consider pipeline implicit transaction as a transaction block
Date: 2024-11-27 23:26:04
Message-ID: Z0eqjIhyFD2SlHMI@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Nov 27, 2024 at 04:20:10PM -0500, Bruce Momjian wrote:
> Yeah, I was surprised too, even though the author was clear they wanted
> to backpatch. I couldn't figure out why it was being backpatched, so I
> figured I was missing something.

The set of inconsistencies of how we decide if one command or the
other should behave differently depending on the use of a pipeline,
on the transaction block state, on the code paths involved and on
MyXactFlags in this case qualified as good enough to me for a
backpatch, in the same lines as 20432f873140 & friends. Also worth
noting is the lack of regression tests back then, some could have been
introduced through pgbench's meta-commands as Anthonin has done here
to provide some combination checks even if the error messages
generated cannot be directly looked at. pgbench was mentioned on the
original thread leading to this commit and the result not include
anything. Anyway, what's done is done..

I don't mind being more careful here based on your concerns, so I'll
go remove that in the stable branches.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sergey Prokhorenko 2024-11-27 23:28:57 Отв.: Re: UUID v7
Previous Message Sergey Prokhorenko 2024-11-27 23:07:49 Re: UUID v7