Re: Seems to be impossible to set a NULL search_path

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Seems to be impossible to set a NULL search_path
Дата
Msg-id 0c649c8e-dfff-7dea-908a-7b68611fd18f@aklaver.com
обсуждение исходный текст
Ответ на Seems to be impossible to set a NULL search_path  (Bryn Llewellyn <bryn@yugabyte.com>)
Ответы Re: Seems to be impossible to set a NULL search_path  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
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.


-- 
Adrian Klaver
adrian.klaver@aklaver.com



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to upgrade postgres version 8 to 13
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Seems to be impossible to set a NULL search_path