<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >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?</div>
<div dir="ltr" > </div>
<blockquote data-history-content-modified="1" dir="ltr" style="border-left:solid #aaaaaa 2px; margin-left:5px; padding-left:5px; direction:ltr; margin-right:0px" >----- Original message -----<br>From: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at><br>To: "Li EF Zhang" <bjzhangl(at)cn(dot)ibm(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org<br>Cc:<br>Subject: [EXTERNAL] Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int<br>Date: Tue, Aug 24, 2021 6:23 PM<br>
<div><font size="2" face="Default Monospace,Courier New,Courier,monospace" >On Tue, 2021-08-24 at 06:21 +0000, Li EF Zhang wrote:<br>> dict_int is trusted extension in pg13. After creating dict_int extension with<br>> unprivileged user, ALTER TEXT SEARCH DICTIONARY intdict ((MAXLEN = 7) failed.<br>> <br>> admin=> ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7);<br>> ERROR: must be owner of text search dictionary intdict<br>> <br>> This is by design or a bug? Thanks!<br><br>You must be the owner of an object to ALTER it. That is working as designed.<br><br>It is a bad idea to ALTER an object that belongs to an extension.<br>The next ALTER EXTENSION ... UPDATE may undo the change or fail.<br><br>Create your own dictionary with the same template.<br><br>Yours,<br>Laurenz Albe<br>--<br>Cybertec | <a href="https://www.cybertec-postgresql.com" target="_blank">https://www.cybertec-postgresql.com</a> </font><br> </div></blockquote>
<div dir="ltr" > </div></div><BR>
<BR>