Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwBQR-00HRNO-EQ for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Apr 2024 01:46:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rwBQP-009a2P-TS for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Apr 2024 01:46:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwBQP-009a2G-1A for pgsql-hackers@lists.postgresql.org; Mon, 15 Apr 2024 01:46:25 +0000 Received: from wfhigh5-smtp.messagingengine.com ([64.147.123.156]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rwBQM-002tAa-8Z for pgsql-hackers@postgresql.org; Mon, 15 Apr 2024 01:46:23 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailfhigh.west.internal (Postfix) with ESMTP id 9296C18000E3; Sun, 14 Apr 2024 21:46:19 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Sun, 14 Apr 2024 21:46:20 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1713145579; x=1713231979; bh=tMdO4qUIrK 0w4qf2aIZRz8ho06jdUqrQZnXqYFGst7c=; b=Le98D0BUY9ThVWAgT2FqEgf7UM lvyr7xvC64iOM/vdNnPqYWdbeqQnB0y4Jij4bHych+VGnPKcyeYkfa57Jgj7qnBs 4igDzKZyZexU+ZKSjq02YhwggwNWt0WK5HxIVUbn1GAgQSb9NO/xK0+D+QisgOKB L5/LITz3IOX1YRzTTHKtfI/eUCaZUtCoMp7e1j4eG+R88hYBduJIxX49H9qNJKLe r4c8IBu+VRwhisNztAeykF1nOuDpOQCCpb9Zt0iznJHaJi4ZsJDI9t9nqxacMeS1 X/jsLVDu5r7R+KFUeIZQNfXzGfHBnLW3jursj2B1XlYM92+klWS9v0q+oqyQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1713145579; x=1713231979; bh=tMdO4qUIrK0w4qf2aIZRz8ho06jd UqrQZnXqYFGst7c=; b=uC659oIbewVmg44mlE4SnWjYufJY6c4McRH70Tw3TvbE 3dnqq5KWlf47dopERUZqby50yEz3QQPzwBj6GlMWhAwi+0fIsweNjgRHMpiUiI3r 6TrZO2iSZqu3se5yGPWs4Nt7nf22va0wmgQHSDLIlW+lTMfZ1u+A3zQyWEq0nFmu QAICqIwO6E7onMnYYydBpcrGcaoHiN4Qx+DVD+f29xxcaK87bJzotvLQ77gBHkdO ANmBfd1TwxIMnE6GzfaTwy3sbVQeHAcCJxTw06q1ifPWIYu2HPk06EEIOq1ymQBL 9Qo5RUiAQ835rJametdGZB3Q52o1KgcFnWEUHNPaiQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudejuddgtddvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 14 Apr 2024 21:46:15 -0400 (EDT) Date: Mon, 15 Apr 2024 10:46:00 +0900 From: Michael Paquier To: Tom Lane Cc: Justin Pryzby , Alexander Lakhin , Alvaro Herrera , Peter Eisentraut , Soumyadeep Chakraborty , Zhihong Yu , pgsql-hackers@postgresql.org, Ashwin Agrawal , vanjared@vmware.com Subject: Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Message-ID: References: <202403281558.xk5pgf7ur3dq@alvherre.pgsql> <1464385.1712034366@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="gciiKiIQnJ8DaACP" Content-Disposition: inline In-Reply-To: <1464385.1712034366@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --gciiKiIQnJ8DaACP Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Apr 02, 2024 at 01:06:06AM -0400, Tom Lane wrote: > AFAICS, e2395cdbe posits that taking exclusive lock on pg_am in the > middle of a bunch of concurrent regression scripts couldn't possibly > cause any problems. Really? There is no need for a catalog here to trigger the failure, and it would have happened as long as a foreign table is used. The problem introduced in 374c7a229042 fixed by e2395cdbe83a comes from a thinko on my side, my apologies for that and the delay in replying. Thanks for the extra fix done in 13b3b62746ec, Alvaro. -- Michael --gciiKiIQnJ8DaACP Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmYchtgACgkQnvQgOdby QH2F8g/9G752bg1Rc0dkXe8vzrayas92/KJz0Py+XWIOGSA+z5lNRGHhLET6eAvq ps8z9NPdgeCtjN4KQFD85Gpd2SdDa4UPAQvAT9kZrDWDIW4pCLml417KFx354qh8 DqHl29EITKgPHrsGHP2CcqlaqLs3kuEFVjtm8HuH8r+rxgUuCUxp3f2Z01akXtXQ 95/QLS7C6nSSO48Y5jA20cWAUh/sPiwGYnsqpSlFerfAYrMry0DPf7Figdyhpep6 ABkMhlKy3Ur3t13JpEuBX9ttx4jISC7G466nT4oVEeqvZMPawX1j4mrE7KuFrp5V ywF0naJBYIZ8jam9Cjlg/bB+8OPJ5jxfrXaSyRDjyF6odeYNlRaBmC9h7NEkUQ7V f6yHm7Me8VW/KLv1JeykmiDu3KXtS/Ppi8/UIdKvL/TlVCzVAz1ls4Tv4sfV0m4b 93gjUuOf4pph3GG4ZCCD31Fx5VyyzTRww4rLpZfLQT+oQdmchHsLt7PifzmRD/V3 QbzeoQVGLgSJPsOMAW6c2qvr+0ASxn+4CDy/pg+kmyClxztPiQMKJNPfmMlNvp6V CX0y+HEXK5X2nm3kZDd61ZT8554RadenP7o8oPs1xCVocfK7vo6/DLYnhlHqlu/F X6a9nfEgE3vPf9SrAXbSLMa0kGHCml0oULx00BEnwRYBw+b9iH4= =Ywnx -----END PGP SIGNATURE----- --gciiKiIQnJ8DaACP--