From: Ronan Dunklau <ronan.dunklau@aiven.io>
To: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Subject: Re: Converting contrib SQL functions to new style
Date: Tue, 29 Oct 2024 08:28:55 +0100
Message-ID: <3316564.aeNJFYEL58@aivenlaptop>
In-Reply-To: <2102171.1630517255@sss.pgh.pa.us>
References: 
 <3395418.1618352794@sss.pgh.pa.us>
 <icwj06MeNjimdlNmL6h9X5bmqwe0QngwSOzunFna3RS9fYIxyAFMi7UG7hOp4CQTmFEHDkdhG3z9iBpXHBwNOA==@protonmail.internalid>
 <2102171.1630517255@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="nextPart3322926.44csPzL39Z"
Content-Transfer-Encoding: 7Bit
Archived-At: 
 <https://www.postgresql.org/message-id/3316564.aeNJFYEL58%40aivenlaptop>
Precedence: bulk

This is a multi-part message in MIME format.

--nextPart3322926.44csPzL39Z
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="utf-8"

Le mercredi 1 septembre 2021, 19:27:35 heure normale d=E2=80=99Europe centr=
ale Tom=20
Lane a =C3=A9crit :
> The rest of this is stuck pending investigation of the ideas about
> making new-style function creation safer when the creation-time path
> isn't secure, so I suppose we should mark it RWF rather than leaving
> it in the queue.  Will go do that.

Sorry to revive such an old thread but ... since the introduction of the=20
@extschema:name@ syntax in 72a5b1fc880481914da2d4233077438dd87840ca we can =
now=20
proceed with this or am I missing something ?

I've updated the previous patches to convert them to the new-style, added o=
ne=20
for lo as well. Most of them are just patching against a newer extension=20
version than what was provided at the time, except for earthdistance which =
now=20
references everything explicitly by pg_catalog or @extschema:cube@.=20

This is a bit tangential to the initial subject, but take the opportunity t=
o=20
also update the CREATE DOMAIN statement in earthdistance extension to=20
explicitly reference the cube schema.

Best regards,

=2D-
Ronan Dunklau
--nextPart3322926.44csPzL39Z
Content-Disposition: attachment;
 filename="v2-0005-Use-new-style-SQL-function-in-xml2-extension.patch"
Content-Transfer-Encoding: 7Bit
Content-Type: text/x-patch; charset="UTF-8";
 name="v2-0005-Use-new-style-SQL-function-in-xml2-extension.patch"