RE: BUG #17157: authorizaiton of dict_int and bloom extention

<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >Got it! Thanks!</div>
<div dir="ltr" >My question:</div>
<div dir="ltr" >1. If an ordinary user create the extension, my understanding is that the object created in the extension should be the user who create the extension?</div>
<div dir="ltr" >2. Will the fix for bloom be applied on pg13?</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >&nbsp;</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: "Neil Chen" &lt;carpenter(dot)nail(dot)cz(at)gmail(dot)com&gt;<br>To: bjzhangl(at)cn(dot)ibm(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org<br>Cc:<br>Subject: [EXTERNAL] Re: BUG #17157: authorizaiton of dict_int and bloom extention<br>Date: Tue, Aug 24, 2021 4:38 PM<br>&nbsp;<br>
<div dir="ltr" ><div dir="ltr" >&nbsp;</div>&nbsp;

<div><div dir="ltr" >On Tue, Aug 24, 2021 at 4:19 PM PG Bug reporting form &lt;<a href="mailto:noreply(at)postgresql(dot)org" target="_blank" >noreply(at)postgresql(dot)org</a>&gt; wrote:</div>
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" >The following bug has been logged on the website:<br><br>Bug reference:&nbsp; &nbsp; &nbsp; 17157<br>Logged by:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Lily Zhang<br>Email address:&nbsp; &nbsp; &nbsp; <a href="mailto:bjzhangl(at)cn(dot)ibm(dot)com" target="_blank" >bjzhangl(at)cn(dot)ibm(dot)com</a><br>PostgreSQL version: 13.3<br>Operating system:&nbsp; &nbsp;os390x<br>Description:&nbsp; &nbsp; &nbsp; &nbsp;<br><br>1. Since dict_int is trusted, we create extension of dict_int with normal<br>user. But when alter maxlen of intdict, it reports error. This is the<br>detail.<br>```<br>admin=&gt; create extension dict_int;<br>CREATE EXTENSION<br>admin=&gt; ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7);<br>ERROR:&nbsp; must be owner of text search dictionary intdict<br>```<br>2. Since pg13 supports trusted extension, we make bloom trusted by changing<br>control file. Everything runs well except drop extension with normal user<br>who creates this extension.<br>```<br>test=&gt; create extension bloom;<br>CREATE EXTENSION<br>test=&gt; drop extension bloom;<br>ERROR:&nbsp; must be superuser to drop access methods<br>```<br>&nbsp;</blockquote></div>
<div>&nbsp;</div>Hi, here are some of my understanding, hope it can help you:

<div>&nbsp;</div>
<div>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".
<div>&nbsp;</div>
<div>For (2), it was already been fixed in commit:&nbsp;<span style="color:rgb(36,41,46);font-family:ui-monospace,SFMono-Regular,&quot;SF Mono&quot;,Menlo,Consolas,&quot;Liberation Mono&quot;,monospace;font-size:12px;text-align:right;white-space:nowrap" >b1d32d3e3230f00b5baba08f75b4f665c7d6dac6.</span>
<div>&nbsp;</div>--

<div dir="ltr" ><div dir="ltr" >There is no royal road to learning.
<div>HighGo Software Co.</div></div></div></div></div></div></blockquote>
<div dir="ltr" >&nbsp;</div></div><BR>
<BR>