Re: Converting contrib SQL functions to new style

From: Ronan Dunklau <ronan(dot)dunklau(at)aiven(dot)io>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
Subject: Re: Converting contrib SQL functions to new style
Date: 2024-10-29 07:28:55
Message-ID: 3316564.aeNJFYEL58@aivenlaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le mercredi 1 septembre 2021, 19:27:35 heure normale d’Europe centrale Tom
Lane a écrit :
> 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
@extschema:name@ syntax in 72a5b1fc880481914da2d4233077438dd87840ca we can now
proceed with this or am I missing something ?

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

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

Best regards,

--
Ronan Dunklau

Attachment Content-Type Size
v2-0005-Use-new-style-SQL-function-in-xml2-extension.patch text/x-patch 1.2 KB
v2-0006-Use-new-style-SQL-function-in-lo-extension.patch text/x-patch 1.6 KB
v2-0004-Use-new-style-SQL-function-in-pg_freespacemap-ext.patch text/x-patch 2.4 KB
v2-0003-Use-new-style-SQL-function-in-pageinspect-extensi.patch text/x-patch 3.6 KB
v2-0002-Use-new-style-SQL-function-in-earthdistance-exten.patch text/x-patch 8.5 KB
v2-0001-Use-new-style-SQL-function-in-citext-extension.patch text/x-patch 5.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Guo 2024-10-29 07:51:37 Re: Eager aggregation, take 3
Previous Message Pavel Stehule 2024-10-29 07:16:42 Re: proposal: schema variables