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 1tAmIY-0004n4-TR for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Nov 2024 08:30:54 +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 1tAmIW-004HIR-1w for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Nov 2024 08:30:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAmIU-004HII-Sa for pgsql-hackers@lists.postgresql.org; Tue, 12 Nov 2024 08:30:52 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAmIQ-001VHb-5o for pgsql-hackers@lists.postgresql.org; Tue, 12 Nov 2024 08:30:50 +0000 Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id C76F9114020C; Tue, 12 Nov 2024 03:30:44 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Tue, 12 Nov 2024 03:30:44 -0500 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=fm3; t=1731400244; x=1731486644; bh=z4M2UG5xqH wcwdcO/y5jgb2JEHKq6A4qVFyWlLLI28I=; b=IbbISWVg6NO2+U007EPkyb80eZ BqG0DSEXslmFFrvat/HMr8zU+1FEH4rG2xQ/mXY966T71ZjP5Rlw07YXXEFwCVl3 SqOCTR0VSHF3M3g+NxhoomvjGukOZYC0WpaQv5vA+/sSJ23Se87dn+xH6W5rmtOO 8aForWGCi1HlL8llZDKksSx32Tq8S44ri2GZXRJITvq2kMbgz10/RfBh7hFi6OU3 2kpx2w1z0pRYaplqjtScAcSEhEu06jorhAtxUgT7tbD1TGj2XgziylaH4JHGlbnP Beun7JD260p6EhmeAnaCNJZUj+zrwvjQnxvRpSQJol4W9HQQlE4V1KAveOPQ== 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-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1731400244; x=1731486644; bh=z4M2UG5xqHwcwdcO/y5jgb2JEHKq6A4qVFy WlLLI28I=; b=Yj9mHYIxF9aavvJ/I+e4F9UB0Ho9PHiVAr2AWP2t1QPSUe+/Cqv 6Rc5zD0g2EHFOtWgcJKR+rZPGOnrYaIKy7aEwxwwNV6zlePIniThsMKiXHDb+wKe +7RRK9ytJ8fHExXExmiTgA09DgdRIFPmPeIhkhEbWbkPQFMrxtRLjAYf6T3wpWIe JA0YDBx39rYiTa61hIEydazC9wiajifOR4S94nl1+7imaPWvunOfRMNbuKr3uRdc vSCmG4npBk3v+sAIOcSh4zgrd74ka1jOfs1oGOOMegw+xuMGK8pLRl1ISNyK2bGK BERPXy/gxFRQVOa2AujNQs+74U5bKbjqMuA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudefgdduudelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtdorredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepueeh jeefleeigfelheetveegvddvfedtveejveelleetgeekteeukeetgefgveeunecuffhomh grihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipd hnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehrohhn rghnrdguuhhnkhhlrghusegrihhvvghnrdhiohdprhgtphhtthhopehtghhlsehsshhsrd hpghhhrdhprgdruhhspdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishht shdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepphgvthgvrhdrvghishgvnh htrhgruhhtsegvnhhtvghrphhrihhsvggusgdrtghomh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 12 Nov 2024 03:30:42 -0500 (EST) Date: Tue, 12 Nov 2024 17:30:30 +0900 From: Michael Paquier To: Ronan Dunklau Cc: Tom Lane , pgsql-hackers@lists.postgresql.org, Peter Eisentraut Subject: Re: Converting contrib SQL functions to new style Message-ID: References: <3395418.1618352794@sss.pgh.pa.us> <3133933.1730855116@sss.pgh.pa.us> <5829980.DvuYhMxLoT@aivenlaptop> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="dSKsZCaXRIwF59wO" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --dSKsZCaXRIwF59wO Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Nov 07, 2024 at 10:06:37AM +0900, Michael Paquier wrote: > Good point. Checking all these contrib updates one-by-one is an ant's > work, but I'll see if I can get at least some of them done on HEAD. I've begun looking at that a bit, and there are a couple of things that we could do better with xml2 in 0005 at least in the context of this patch: xpath_nodeset() and xpath_list() don't have any test coverage. That's not an issue directly related to this patch, but perhaps we should add something for the functions that we are manipulating after this upgrade path at least? That's one way to=20 automatically make sure that these changes work the same way as the original. The same argument comes up with lo_oid() in 0006.=20 0004 for pg_freespace is fine regarding that for example as we have calls of pg_freespace(regclass) in its sql/. I've applied it to begin with something. Tomas Vondra has posted a patch for a bug fix with pageinspect, so this would create some conflicts noise for him if 0003 was applied today, so let's wait a bit: https://www.postgresql.org/message-id/3385a58f-5484-49d0-b790-9a198a0bf236@= vondra.me 0001 and 0002 are much larger than the 4 others, and I'm lacking the steam to check them in more details today. -- Michael --dSKsZCaXRIwF59wO Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmczEiYACgkQnvQgOdby QH11uw//dZWSvhyH5860uTjefPff5STFFSHMaAOl0uWxwv0Ip8hFHkF94ddTJKIi QNOy9iD9SIMm4VQVSnOeA9BYlj34riNWyy/ZKEcVC4ogqT+xpF79/1y7Ayn5MYzF TInhtMWko8V6SOIQ2uFEvjp/SDfMmJHvZtlcDCO/+L5HHvr5lLhU74DftytcTgqm 0mUXA9JQH3lqe+ySq2BbkY8+Ik5Vcm4CryboCQuvC0Z7rgS0mlrPm2n3q2E+8ME5 cnDAN4uqG2wsRdXbwFas+UcZ2teFi7ToSJo99m9Z1vFmRCdG91Gb5zfupmtfKNzg OMqBPZOE5hjKgTMcJhHhAofFY78Axxa9CLHqNavedhRsDT56R2V4GtpcWBeLSLFp s//48zUAYp0oXaA7ucvonyBW4lbubUXpQcPFyaaxwSTwTRpd1eapqD4hdA20E5Oy yCN0ZSL7xqg+6ayo4NIo1pTOd+AkYZuwYIfTzu8QG3Tb8lbPs5tYr6K5P8OLAspo viNKyn7AwWV7xbZtBrAeegCh3utPIeMEmIP9u8NBhrAZCp1Z+DiVP9jMG9wXo5vX c0nryURFcLf87Eo1BYivsnkycnfmukpsZItZ8bxIsuydlZ66lcg0ulHVtMDzT6qx HXOpS4/pJQDNpXpY1yg2gZZKuyem/jTkreVUCdOAapkypTDpWrI= =Rqaj -----END PGP SIGNATURE----- --dSKsZCaXRIwF59wO--