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

On Wed, Aug 25, 2021 at 12:38 AM David G. Johnston wrote: > > On Tue, Aug 24, 2021 at 8:17 AM Adrian Klaver > wrote: >> >> >> To me the issue is that the extension was modified to trusted by an end >> user not the extension author. I gotta believe there is more to the >> trusted then a flag in t

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

On Tue, Aug 24, 2021 at 8:17 AM Adrian Klaver wrote: > > To me the issue is that the extension was modified to trusted by an end > user not the extension author. I gotta believe there is more to the > trusted then a flag in the control file. It would not be surprising to > me that an ad hoc modif

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

On 8/24/21 7:40 AM, David G. Johnston wrote: On Fri, Aug 20, 2021 at 6:26 AM Tom Lane > wrote: "Li EF Zhang" mailto:bjzha...@cn.ibm.com>> writes: > Since pg13 support trusted extension, so I changed control file of bloom and make it trusted. The fact

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

"David G. Johnston" writes: > On Fri, Aug 20, 2021 at 6:26 AM Tom Lane wrote: >> "Li EF Zhang" writes: >>> Since pg13 support trusted extension, so I changed control file of bloom >>> and make it trusted. >> The fact that you can edit the file that way doesn't make it a supported >> case. > Wh

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

On Fri, Aug 20, 2021 at 6:26 AM Tom Lane wrote: > "Li EF Zhang" writes: > > Since pg13 support trusted extension, so I changed control file of bloom > and make it trusted. > > The fact that you can edit the file that way doesn't make it a supported > case. > > Why does that matter here though?

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

On Sat, Aug 21, 2021 at 1:09 PM Mladen Gogala wrote: > Why do you think that the normal user should be allowed to drop > extensions? The documentation. https://www.postgresql.org/docs/current/sql-createextension.html "This configuration gives the calling user the right to drop the extension,

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

Why do you think that the normal user should be allowed to drop extensions? Extensions are additions to the RDBMS functionality. Do you really want normal users to tinker with the database functionality and reduce the number of index types you can create? I am not sure that I am on board with t

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

"Li EF Zhang" writes: > Since pg13 support trusted extension, so I changed control file of bloom and > make it trusted. The fact that you can edit the file that way doesn't make it a supported case. regards, tom lane

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

Hi all,   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.   test=> create extension bloom;CREATE EXTENSIONtest=> drop extension bloom;ERROR:  mu