Perhaps silly question about empty search_path

From: Jerry Sievers <jerry(at)jerrysievers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Perhaps silly question about empty search_path
Date: 2007-10-21 00:19:32
Message-ID: m3lk9xgvzf.fsf@mama.jerrysievers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)jerry#
= alter database jerry set search_path to '';
NOTICE: schema "" does not exist
ALTER DATABASE
jerry(at)jerry#
= set search_path to '';
ERROR: schema "" does not exist
jerry(at)jerry#
= \c jerry
You are now connected to database "jerry".
jerry(at)jerry#
= show search_path;
search_path
-------------
""
(1 row)

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2007-10-21 00:46:47 Re: Perhaps silly question about empty search_path
Previous Message Rainer Bauer 2007-10-20 22:27:41 Fwd: Re[2]: 8.2.3: Server crashes on Windows using Eclipse/Junit