Re: Seems to be impossible to set a NULL search_path

[Christophe Pettus]

> On Jul 5, 2022, at 11:12, Bryn Llewellyn <b...@yugabyte.com> wrote:
> Finally, what do you think of a possible future enhancement to allow setting 
> a null search_path?

You use the empty string, rather than NULL, but it works right now:

xof=# show search_path;
   search_path   
-----------------
 "$user", public
(1 row)

xof=# select * from t;
 i | d1 | d2 
---+----+----
(0 rows)

xof=# set search_path='';
SET
xof=# show search_path;
 search_path 
-------------
 ""
(1 row)

xof=# select * from t;
ERROR:  relation "t" does not exist
LINE 1: select * from t;
                      ^
xof=#