Thread: Perhaps silly question about empty search_path

Hello;

To begin with, I'm not certain how useful it would be... that said; it
seems odd that a role or DB can have it's config search_path set to
empty string but you can't explicitly set it that way.

One possible use for this might be to force complete schema
qualification when developing  DB update scripts.

Comments?


jerry@jerry#
= select version();
                                              version
---------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20060525 (Red Hat 4.1.1-1)
(1 row)

jerry@jerry#
= alter database jerry set search_path to '';
NOTICE:  schema "" does not exist
ALTER DATABASE
jerry@jerry#
= set search_path to '';
ERROR:  schema "" does not exist
jerry@jerry#
= \c jerry
You are now connected to database "jerry".
jerry@jerry#
= show search_path;
 search_path
-------------
 ""
(1 row)

jerry@jerry#
=
--
-------------------------------------------------------------------------------
Jerry Sievers   732 365-2844 (work)     Production Database Administrator
                305 321-1144 (mobil    WWW E-Commerce Consultant

Jerry Sievers <jerry@jerrysievers.com> writes:

> Hello;
>
> To begin with, I'm not certain how useful it would be... that said; it
> seems odd that a role or DB can have it's config search_path set to
> empty string but you can't explicitly set it that way.

Ugh!

Sorry.  I forgot to see if set_config('search_path', '', true/false) does
the trick and it does.

Well, anyway... I got stuck on it since accomplishing what I had
intended wasn't straight forward :-)

Thanks

--
-------------------------------------------------------------------------------
Jerry Sievers   732 365-2844 (work)     Production Database Administrator
                305 321-1144 (mobil    WWW E-Commerce Consultant