Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSlKH-0001hg-LD for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Mar 2022 19:53:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nSlKG-0007Mc-BS for pgsql-bugs@arkaria.postgresql.org; Fri, 11 Mar 2022 19:53:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSlKG-0007MR-2S for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 19:53:24 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nSlK9-0006f3-Un for pgsql-bugs@lists.postgresql.org; Fri, 11 Mar 2022 19:53:22 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 22BJrCJ5982895; Fri, 11 Mar 2022 14:53:12 -0500 From: Tom Lane To: Masahiko Sawada cc: Dmitry Koval , Dilip Kumar , andrewbille@gmail.com, PostgreSQL mailing lists Subject: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end In-reply-to: References: <17385-9ee529fb091f0ce5@postgresql.org> <6e31c4ef-de9a-960b-1a21-e3b6ff0fa9c2@postgrespro.ru> <2733419.1644789029@sss.pgh.pa.us> <2778050.1644817168@sss.pgh.pa.us> <3054063.1644944122@sss.pgh.pa.us> <515672.1646838707@sss.pgh.pa.us> Comments: In-reply-to Masahiko Sawada message dated "Sat, 12 Mar 2022 00:39:53 +0900" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <982893.1647028392.1@sss.pgh.pa.us> Date: Fri, 11 Mar 2022 14:53:12 -0500 Message-ID: <982894.1647028392@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Masahiko Sawada writes: > I've attached a draft patch for discussion. Hm, I think that trying to RESET a GUC_NO_RESET variable ought to actively throw an error. Silently doing nothing will look like a bug. (This does imply that it's not sensible to mark a variable GUC_NO_RESET without also saying GUC_NO_RESET_ALL. That seems fine to me, because I'm not sure what the combination GUC_NO_RESET & !GUC_NO_RESET_ALL ought to mean.) regards, tom lane