RE: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

2021-08-24 Thread Li EF Zhang
Got it! Thank you all very much!   - Original message -From: "David G. Johnston" To: "Tom Lane" Cc: "Li EF Zhang" , "Laurenz Albe" , "pgsql-generallists.postgresql.org" Subject: [EXTERNAL] Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_intDate: Wed, Aug 25, 2021 1

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

2021-08-24 Thread David G. Johnston
On Tue, Aug 24, 2021 at 9:20 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang wrote: > >> 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 > >> with

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

2021-08-24 Thread Tom Lane
"David G. Johnston" writes: > On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang wrote: >> 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? > While that is a possible implementation

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

2021-08-24 Thread David G. Johnston
On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang wrote: > 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? > While that is a possible implementation choice, that isn't what was chos

RE: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

2021-08-24 Thread Li EF Zhang
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" To: "Li EF Zhang" , pgsql-general@lists.postgresql.orgCc:Subject: [EXTERNAL] Re: Ca

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

2021-08-24 Thread Laurenz Albe
On Tue, 2021-08-24 at 06:21 +, 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 ow