Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int
Дата
Msg-id CAKFQuwYHO8=5MjpUJgmLCJTz_okaUWVVqADhcJ84tukMTEATqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang <bjzhangl@cn.ibm.com> wrote:
Thanks for your answer. My doubt is that since an ordinary user creates the extension, shouldn't be this user the owner of the objects created within the extension?

While that is a possible implementation choice, that isn't what was chosen.

https://www.postgresql.org/docs/current/sql-createextension.html

"This configuration gives the calling user the right to drop the extension, but not to modify individual objects within it."

"trust" just solves the "lets not require an actual superuser to install a superuser requiring extension" problem, if that extension is deemed safe to use in that manner by its author.

David J.

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

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