Thanks for your answer. My doubt is that since an ordinary user creates the extension, shouldn't be this user the owner of the objects created within the extension?
----- Original message -----
From: "Laurenz Albe" <laurenz.albe@cybertec.at>
To: "Li EF Zhang" <bjzhangl@cn.ibm.com>, pgsql-general@lists.postgresql.org
Cc:
Subject: [EXTERNAL] Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int
Date: Tue, Aug 24, 2021 6:23 PM
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