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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
