Re: Seems to be impossible to set a NULL search_path

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Seems to be impossible to set a NULL search_path
Дата
Msg-id CAFj8pRA2fHFe-zqxnuR27MVGE+waKWsPoDAVD3W3iMj9TTFDjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Seems to be impossible to set a NULL search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Seems to be impossible to set a NULL search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения


út 5. 7. 2022 v 20:18 odesílatel Adrian Klaver <adrian.klaver@aklaver.com> napsal:
On 7/5/22 11:12 AM, Bryn Llewellyn wrote:
> The section "Writing SECURITY DEFINER Functions Safely":
>
> https://www.postgresql.org/docs/current/sql-createfunction.html#id-1.9.3.67.10.2
>

> Finally, what do you think of a possible future enhancement to allow setting a null search_path?
>

set search_path = '';

show search_path ;
  search_path
-------------
  ""

\d
Did not find any relations.

But still in this case, there is pg_catalog in search path.

Regards

Pavel
 


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Seems to be impossible to set a NULL search_path
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Seems to be impossible to set a NULL search_path