From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael@paquier.xyz>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: Dmitry Koval <d.koval@postgrespro.ru>
Cc: Dilip Kumar <dilipbalaut@gmail.com>
Cc: andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org, Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Subject: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end
Date: Mon, 26 Sep 2022 00:07:50 -0400
Message-ID: <3268290.1664165270@sss.pgh.pa.us> (raw)
In-Reply-To: <YzEfR9UUb3gqRjoA@paquier.xyz>
References: <CAD21AoDWHkBBGvvJuLEBqMjiPiYOiVJ6voFBWYbOBsU+-Cot2A@mail.gmail.com>
<20220628003720.GG19662@telsasoft.com>
<CAD21AoBz4xZ3uOZS+xYENsYta4PPPkGYPDzzPqqw5GJgrQC7hg@mail.gmail.com>
<Yrv1nRsfasco768G@paquier.xyz>
<CAD21AoC8FQqHY8knG7+6-eQe39wjXPtqyki29OAb5OHhq7-p+Q@mail.gmail.com>
<CAD21AoD6n62NXB5OuYSONYHKNkR=fqvJ5+82y=4Z=-KuFeOV0w@mail.gmail.com>
<2604497.1664053071@sss.pgh.pa.us>
<YzEfR9UUb3gqRjoA@paquier.xyz>
Michael Paquier <michael@paquier.xyz> writes:
> Just to be sure about something here. The change of behavior with SET
> in the context of a PL makes this patch unsuitable for a backpatch,
> hence the plan is to apply this stuff only on HEAD, right?
Yeah, I think we concluded that back-patching might cause more
trouble than it's worth.
> + <entry><literal>NO_RESET</literal></entry>
> + <entry>Parameters with this flag do not support
> + <command>RESET</command> commands.
> + </entry>
> As per the issue with SET commands used with functions, this
> description does not completely reflect the reality.
It seems adequate enough to me ... do you have a suggestion?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, michael@paquier.xyz, sawada.mshk@gmail.com, pryzby@telsasoft.com, d.koval@postgrespro.ru, dilipbalaut@gmail.com, horikyota.ntt@gmail.com
Subject: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end
In-Reply-To: <3268290.1664165270@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox