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