Ășt 5. 7. 2022 v 20:18 odesĂ­latel Adrian Klaver <adrian.kla...@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.kla...@aklaver.com
>
>
>

Reply via email to