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 1oe6i2-000325-VO for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Sep 2022 03:29:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oe6i1-0006qh-Ps for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Sep 2022 03:29:05 +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 1oe6i1-0006qY-GB for pgsql-hackers@lists.postgresql.org; Fri, 30 Sep 2022 03:29:05 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oe6hz-0002Qb-Af for pgsql-hackers@lists.postgresql.org; Fri, 30 Sep 2022 03:29:04 +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 28U3StAF522210; Thu, 29 Sep 2022 23:28:55 -0400 From: Tom Lane To: Andrew Dunstan cc: Nikita Glukhov , Robert Haas , Andres Freund , "Jonathan S. Katz" , Amit Langote , Alvaro Herrera , PostgreSQL Hackers , Michael Paquier , John Naylor Subject: Re: SQL/JSON features for v15 In-reply-to: References: <20220830092008.6dbublx6la226zis@alvherre.pgsql> <2276d20d-43ff-f9f6-5c9c-c2875739e66c@postgresql.org> <20220831154916.pgspuz3bp4427int@awork3.anarazel.de> <4151123.1661961884@sss.pgh.pa.us> <13351.1661965592@sss.pgh.pa.us> <14814.1661966096@sss.pgh.pa.us> <379e5365-9670-e0de-ee08-57ba61cbc976@postgrespro.ru> <0574201c-bd35-01af-1557-8936f99ce5aa@postgrespro.ru> Comments: In-reply-to Andrew Dunstan message dated "Thu, 29 Sep 2022 23:05:07 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <522208.1664508535.1@sss.pgh.pa.us> Date: Thu, 29 Sep 2022 23:28:55 -0400 Message-ID: <522209.1664508535@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andrew Dunstan writes: > I suggest just submitting the Input function stuff on its own, I think > that means not patches 3,4,15 at this stage. Maybe we would also need a > small test module to call the functions, or at least some of them. > The earlier we can get this in the earlier SQL/JSON patches based on it > can be considered. +1 > . proissafe isn't really a very informative name. Safe for what? maybe > proerrorsafe or something would be better? I strongly recommend against having a new pg_proc column at all. I doubt that you really need it, and having one will create enormous mechanical burdens to making the conversion. (For example, needing a catversion bump every time we convert one more function, or an extension version bump to convert extensions.) regards, tom lane