| 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: | Whole Thread | Raw Message | 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 | 
| 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 |