Re: PG 13 trusted extensions and pg_available_extensions

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: "Daniel Westermann (DWE)" <daniel(dot)westermann(at)dbi-services(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PG 13 trusted extensions and pg_available_extensions
Date: 2020-09-24 02:58:26
Message-ID: 20200924025826.GF7405@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 23, 2020 at 03:28:45PM +0000, 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
> identify extensions that can be installed as "normal" user.

Adding the trusted flag makes sense for visibility. There is a bit
more that we could consider though? For example, what about
"relocatable" and "requires"?
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2020-09-24 03:15:42 Re: PG 13 trusted extensions and pg_available_extensions
Previous Message raf 2020-09-23 23:18:17 Re: PostgreSQL on Windows' state