Re: PG 13 trusted extensions and pg_available_extensions

2020-09-26 Thread Julien Rouhaud
On Sat, Sep 26, 2020 at 10:11 PM Tom Lane wrote: > > Julien Rouhaud writes: > > So, apparently pg_available_extension_versions already had those > > fields so all the required infrastructure was already there. I just > > added the exact same fields to pg_available_extensions, see attached > >

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-26 Thread Tom Lane
Julien Rouhaud writes: > So, apparently pg_available_extension_versions already had those > fields so all the required infrastructure was already there. I just > added the exact same fields to pg_available_extensions, see attached > patch. The reason that pg_available_extensions has only the

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-26 Thread Julien Rouhaud
On Fri, Sep 25, 2020 at 2:51 PM Daniel Westermann (DWE) wrote: > > On Thu, Sep 24, 2020 at 10:58 AM Michael Paquier wrote: > >> > >> On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: > >> > I was playing a bit with trusted extensions and wondered if there is > >> > a

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-25 Thread Daniel Westermann (DWE)
On Thu, Sep 24, 2020 at 10:58 AM Michael Paquier wrote: >> >> On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: >> > I was playing a bit with trusted extensions and wondered if there is >> > a reason that the "trusted" flag is not exposed in pg_available_extensions. >> > I

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-23 Thread Julien Rouhaud
On Thu, Sep 24, 2020 at 10:58 AM Michael Paquier wrote: > > On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: > > I was playing a bit with trusted extensions and wondered if there is > > a reason that the "trusted" flag is not exposed in pg_available_extensions. > > I

Re: PG 13 trusted extensions and pg_available_extensions

2020-09-23 Thread Michael Paquier
On Wed, Sep 23, 2020 at 03:28:45PM +, Daniel Westermann (DWE) wrote: > I was playing a bit with trusted extensions and wondered if there is > a reason that the "trusted" flag is not exposed in pg_available_extensions. > I believe that information would be quite useful so one can easily >

PG 13 trusted extensions and pg_available_extensions

2020-09-23 Thread Daniel Westermann (DWE)
Hi, I was playing a bit with trusted extensions and wondered if there is a reason that the "trusted" flag is not exposed in pg_available_extensions. I believe that information would be quite useful so one can easily identify extensions that can be installed as "normal" user. Regards Daniel