Postgres Pro
Downloads
Home   >   mailing lists

Re: Seems to be impossible to set a NULL search_path - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Seems to be impossible to set a NULL search_path
Date
Msg-id CAFj8pRA2fHFe-zqxnuR27MVGE+waKWsPoDAVD3W3iMj9TTFDjw@mail.gmail.com
Whole thread Raw
In response to Re: Seems to be impossible to set a NULL search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Seems to be impossible to set a NULL search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view


ú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 by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Seems to be impossible to set a NULL search_path
Next
From: Adrian Klaver
Date:
Subject: Re: Seems to be impossible to set a NULL search_path