Perhaps silly question about empty search_path

Поиск
Список
Период
Сортировка
От Jerry Sievers
Тема Perhaps silly question about empty search_path
Дата
Msg-id m3lk9xgvzf.fsf@mama.jerrysievers.com
обсуждение исходный текст
Ответы Re: Perhaps silly question about empty search_path  (Jerry Sievers <jerry@jerrysievers.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Rainer Bauer
Дата:
Сообщение: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Perhaps silly question about empty search_path