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

["Li EF Zhang" <bjzhangl@xxxxxxxxxx>]

Hi all,

 

Since pg13 support trusted extension, so I changed control file of bloom and make it trusted. The test provided by pg13 for bloom passed using normal user. But when i tried to drop extension, it failed.

 

test=> create extension bloom;
CREATE EXTENSION
test=> drop extension bloom;
ERROR:  must be superuser to drop access methods
 

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.