Postgres Pro
Downloads
Home   >   mailing lists

Re: Make bloom extension trusted, but can not drop with normal user - Mailing list pgsql-general

From Mladen Gogala
Subject Re: Make bloom extension trusted, but can not drop with normal user
Date
Msg-id dec5d9d2-942f-60b0-d581-87eaf0c1096d@gmail.com
Whole thread Raw
Responses Re: Make bloom extension trusted, but can not drop with normal user  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mark Dilger
Date:
Subject: Re: [E] Regexp_replace bug / does not terminate on long strings
Next
From: Lucas
Date:
Subject: Re: PostgreSQL 9.2 high replication lag