<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >Hi all,</div>
<div dir="ltr" > </div>
<div dir="ltr" >Since pg13 support trusted extension, so I changed control file of bloom and make it trusted. The test provided by pg13 for bloom passed using normal user. But when i tried to drop extension, it failed.</div>
<div dir="ltr" > </div>
<div dir="ltr" ><div>test=> create extension bloom;<br>CREATE EXTENSION<br>test=> drop extension bloom;<br>ERROR: must be superuser to drop access methods<br> </div>
<div>So, I want to know if extensions in contrib dir can be set "trusted" ourselves? If we can, I think drop extension should be allowed by normal user.</div>
<div> </div></div>
<div dir="ltr" > </div></div><BR>
<BR>