Search Postgresql Archives

Re: Seems to be impossible to set a NULL search_path

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





út 5. 7. 2022 v 20:18 odesílatel Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux