Make bloom extension trusted, but can not drop with normal user

From: "Li EF Zhang" <bjzhangl(at)cn(dot)ibm(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Make bloom extension trusted, but can not drop with normal user
Date: 2021-08-20 11:01:48
Message-ID: OFED9079A9.1B20CF85-ON00258737.003BFB25-00258737.003C9739@ibm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10pt" ><div dir="ltr" >Hi all,</div>
<div dir="ltr" >&nbsp;</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" >&nbsp;</div>
<div dir="ltr" ><div>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>&nbsp;</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>&nbsp;</div></div>
<div dir="ltr" >&nbsp;</div></div><BR>
<BR>

Attachment Content-Type Size
unknown_filename text/html 833 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2021-08-20 12:37:25 Re: Selecting table row with latest date
Previous Message Francisco Olarte 2021-08-20 07:22:04 Re: Selecting table row with latest date