1. Since dict_int is trusted, we create extension of dict_int with normal user. But when alter maxlen of intdict, it reports error. This is the detail. ``` admin=> create extension dict_int; CREATE EXTENSION admin=> ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7); ERROR: must be owner of text search dictionary intdict ``` 2. Since pg13 supports trusted extension, we make bloom trusted by changing control file. Everything runs well except drop extension with normal user who creates this extension. ``` test=> create extension bloom; CREATE EXTENSION test=> drop extension bloom; ERROR: must be superuser to drop access methods ```
Hi, here are some of my understanding, hope it can help you:
For (1), if we set an extension "trust", the database will execute the "create" action as a superuser, so the owner of the created object is the superuser. I think this is a "feature", not a "bug".
For (2), it was already been fixed in commit: b1d32d3e3230f00b5baba08f75b4f665c7d6dac6.
