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?
[EMAIL PROTECTED]
= 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)
[EMAIL PROTECTED]
= alter database jerry set search_path to '';
NOTICE: schema "" does not exist
ALTER DATABASE
[EMAIL PROTECTED]
= set search_path to '';
ERROR: schema "" does not exist
[EMAIL PROTECTED]
= \c jerry
You are now connected to database "jerry".
[EMAIL PROTECTED]
= show search_path;
search_path
-------------
""
(1 row)
[EMAIL PROTECTED]
=
--
-------------------------------------------------------------------------------
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
