Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: Seems to be impossible to set a NULL search_path
Date
Msg-id 0c649c8e-dfff-7dea-908a-7b68611fd18f@aklaver.com
Whole thread Raw
In response to Seems to be impossible to set a NULL search_path  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Seems to be impossible to set a NULL search_path
List pgsql-general
Tree view 
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to upgrade postgres version 8 to 13
Next
From: Christophe Pettus
Date:
Subject: Re: Seems to be impossible to set a NULL search_path