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 1o5zFM-0004MM-Sd for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Jun 2022 00:38:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o5zEM-0007j3-K8 for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Jun 2022 00:37:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o5zEM-0007iu-CL for pgsql-bugs@lists.postgresql.org; Tue, 28 Jun 2022 00:37:26 +0000 Received: from mail-qv1-xf29.google.com ([2607:f8b0:4864:20::f29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1o5zEK-0001WF-5Q for pgsql-bugs@lists.postgresql.org; Tue, 28 Jun 2022 00:37:25 +0000 Received: by mail-qv1-xf29.google.com with SMTP id q4so17854263qvq.8 for ; Mon, 27 Jun 2022 17:37:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :in-reply-to:user-agent; bh=xtwSmliJgbPqdQb7qtU+TVs7VTcc7x1D0Rex/Xdo9aY=; b=qfoGrJAK6e4Dle08aK6HZ5TmiYb7Dw7bv7rFKtWw4bZHBiVVi+mBEaBoG7/7wJzFcR QcSAT6CGnP6JOYmnjCoSbIA/9dhUI6Nym4ei1TqeRQ2cGzAkmua6z8EJWjYqGWL1+ZaG +ljUJKsSG4p/Ago15YayiPLfTuL677h5Jk+blyrAQA2dRH+fT3hMYMEsn+kZ+JCp0Ngt dBGJ5hTuGRUmLvqEfZYs9Kzu3eB9weE2tCcfyMA2rih2paT770Ba1UOEMs8xNQibmuQi 3diy0Ak//yGVHat7QKFlAblcYiu7x0IOazAjHAvTFaLsk7bVKBJ41o3XdxvdtZCBjRW9 ReLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:in-reply-to:user-agent; bh=xtwSmliJgbPqdQb7qtU+TVs7VTcc7x1D0Rex/Xdo9aY=; b=JfA0WidlGMs0pxhecek69OpJsGzl0CtDKZiqCziHg8r2I2+Y/95U71DSl8XO3tTPcv jpmSjBPMVHmgkFYgOWK9NHnAvyjJOqK7sd3XRKeEauRQH/R9YwUsRPdFOPQYMjSRsTt2 VF6F5NerxxHq2/SuBs4puDsW6omATgdeB77iVbPgle1zmHeGqW+OKr6srd5GIO42xAyC 0XOQj0boj6lIy87Duk6jSOjt5M9Hv4hScmC8huACAHtruEYgXA1yo6vr7eBAzjIkLskC EK1ADpwBMDaJhtrK1mfJaCy85jGOcZG8Ne8P3g2KB4LIJFjsEtoOaUOXrPKIPh2dr8Du ZzmA== X-Gm-Message-State: AJIora+vIGAcY+AtqsgA1IJAkVS2Tzuv2FrHJI7YeuJjul7gXpoqB8Yk TE3fhGHG3z+iLbS33ZUvxjldoQ== X-Google-Smtp-Source: AGRyM1uqzcSMOfHa1XMRgg5BQRw5/cnojcg6YpMDJN/ryaPQGmzb54FJwxofEEkmwORHSd+QeGkyRQ== X-Received: by 2002:a05:6214:d8d:b0:470:a8ba:a8da with SMTP id e13-20020a0562140d8d00b00470a8baa8damr702058qve.126.1656376642215; Mon, 27 Jun 2022 17:37:22 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id r6-20020a05620a298600b006a6f68c8a87sm10476791qkp.126.2022.06.27.17.37.21 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 27 Jun 2022 17:37:21 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id C93448006D0; Mon, 27 Jun 2022 19:37:20 -0500 (CDT) Date: Mon, 27 Jun 2022 19:37:20 -0500 From: Justin Pryzby To: Tom Lane , Masahiko Sawada Cc: Dmitry Koval , Dilip Kumar , andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org, Kyotaro Horiguchi Subject: Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Message-ID: <20220628003720.GG19662@telsasoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 11, 2022 at 02:53:12PM -0500, Tom Lane wrote: > (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.) On Thu, Mar 24, 2022 at 11:23:57PM +0900, Masahiko Sawada wrote: > Attached an updated patch. I kept the name GUC_NO_RESET but I'll > change it if we find a better name for it. I think guc.sql should check that NO_RESET implies NO_RESET_ALL, or otherwise guc.c could incorporate that logic by checking (NO_RESET | NO_RESET_ALL) -- Justin