Re: BUG #17157: authorizaiton of dict_int and bloom extention - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17157: authorizaiton of dict_int and bloom extention
Date
Msg-id CAKFQuwZftC_3qkJdnZzyxxKKeqaSwJqP-=Z=GMC89fXttgDbgQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17157: authorizaiton of dict_int and bloom extention  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-bugs
On Thu, Aug 26, 2021 at 12:22 AM Masahiko Sawada <sawada.mshk@gmail.com> wrote:

> 2. Will the fix for bloom be applied on pg13?

I think that the commit b1d32d3e3 won't be backpatched to PG13 but
this behavior seems like a bug to me. I would expect that "DROP
EXTENSION trusted-bloom" by non-superuser owner succeeds if it’s a
trusted extension. (“trusted-bloom” here means “bloom” extension you
made trusted by changing the control file)

Looking at the commit b1d32d3e3, the fact that that "DROP EXTENSION
trusted-bloom” by non-superuser can drop the access method belonging
to the extension seems like a side effect of this commit.


Yeah, I said much the same thing on the adjacent thread on this topic.


David J.

pgsql-bugs by date:

Previous
From: constzl
Date:
Subject: Re:Re: Is Backgroundworker.bgw_restart_time is defined in seconds?
Next
From: Tom Lane
Date:
Subject: Re: Is Backgroundworker.bgw_restart_time is defined in seconds?