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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Make bloom extension trusted, but can not drop with normal user
Дата
Msg-id CAKFQuwaEiW0QbDHS0qxmGRcqZQw6O_ieV-14CWY1QG2k0zaWBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Make bloom extension trusted, but can not drop with normal user  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Make bloom extension trusted, but can not drop with normal user  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Aug 24, 2021 at 8:17 AM Adrian Klaver <adrian.klaver@aklaver.com> 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 modification would fail.


If the expected behavior here is that an ordinary user can drop a trusted extension then I do not see how this error could present itself since, just like extension creation, all the flag does is allow the user to become a superuser for purposes of installing (or removing) the extension objects.  Per Tom, the pre-v14 drop behavior is indeed a bug.  It is not going to be back-patched, nor has the documentation been updated to say that DROP EXTENSION is effectively prevented due to the existence of this bug (if you really need superuser to install the extension it seems reasonable it requires the same to drop it).

Per an adjacent thread [1] this has apparently been fixed in v14 at [2] - but if so (not tested it myself) then it seems like an unexpected side-effect since that particular commit seems like a pure refactoring.

David J.

[1] https://www.postgresql.org/message-id/CAA3qoJkW4VzN4ixt-%3Du%3DtY1Di9YrzJNAhrxKdNhtQMJp2iD0Cg%40mail.gmail.com
[2] https://github.com/postgres/postgres/commit/b1d32d3e3230f00b5baba08f75b4f665c7d6dac6

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Make bloom extension trusted, but can not drop with normal user
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int