Re: search_path wildcard?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: search_path wildcard?
Дата
Msg-id CAFj8pRDg0UGkG9=LVRL2-mmJRTK2_KkEuzvzgBRqVDP2LZiR_A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: search_path wildcard?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-general


st 22. 5. 2024 v 19:54 odesílatel Ron Johnson <ronljohnsonjr@gmail.com> napsal:
On Wed, May 22, 2024 at 12:53 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, May 22, 2024, 10:36 Ron Johnson <ronljohnsonjr@gmail.com> wrote:
This doesn't work, and I've found nothing similar:
ALTER ROLE foo SET SEARCH_PATH  = '*';

Correct, you cannot do that.

That would be a helpful feature for administrators, when there are multiple schemas in multiple databases, on multiple servers: superusers get ALTER ROLE foo SET SEARCH_PATH  = '*'; and they're done with it.

It can be pretty dangerous, because you don't specify order of schemas 

Regards

Pavel

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: search_path wildcard?
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: search_path and SET ROLE