On Tue, 2021-08-24 at 06:21 +0000, Li EF Zhang wrote:
> dict_int is trusted extension in pg13. After creating dict_int extension with
> unprivileged user, ALTER TEXT SEARCH DICTIONARY intdict ((MAXLEN = 7) failed.
>
> admin=> ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7);
> ERROR: must be owner of text search dictionary intdict
>
> This is by design or a bug? Thanks!
You must be the owner of an object to ALTER it. That is working as designed.
It is a bad idea to ALTER an object that belongs to an extension.
The next ALTER EXTENSION ... UPDATE may undo the change or fail.
Create your own dictionary with the same template.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com