Re: Make bloom extension trusted, but can not drop with normal user

From: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Make bloom extension trusted, but can not drop with normal user
Date: 2021-08-21 20:08:50
Message-ID: dec5d9d2-942f-60b0-d581-87eaf0c1096d@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Why do you think that the normal user should be allowed to drop
extensions? Extensions are additions to the RDBMS functionality. Do you
really want normal users to tinker with the database functionality and
reduce the number of index types you can create? I am not sure that I am
on board with that idea.

Regards

On 8/20/21 7:01 AM, Li EF Zhang wrote:
> So, I want to know if extensions in contrib dir can be set "trusted"
> ourselves? If we can, I think drop extension should be allowed by
> normal user.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lucas 2021-08-22 23:43:59 Re: PostgreSQL 9.2 high replication lag
Previous Message Mark Dilger 2021-08-20 20:26:37 Re: [E] Regexp_replace bug / does not terminate on long strings