From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: set search_path command
Date: Mon, 02 Jun 2014 19:15:51 -0400
Message-ID: <25656.1401750951@sss.pgh.pa.us> (raw)
In-Reply-To: <1401746452731-5805809.post@n5.nabble.com>
References: <CAJYcdTuW815KJ6enWLxNY__ZD5HJOuThmDhJT4i4b541TFL8=Q@mail.gmail.com>
<1401746452731-5805809.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
David G Johnston <david.g.johnston@gmail.com> writes:
> Radovan Jablonovsky wrote
>> Is this new behaviour intentional?
> Yes. It was felt the 9.1 behavior was too punishing. I do not recall the
> specifics at the moment but I believe 9.0- and 9.2+ simply ignore the
> missing schema while 9.1 has the obnoxious behavior that you see. Though if
> any version other than 9.1 and 9.3 matter you should confirm this for
> yourself.
A quick check says that an interactive "SET search_path = nosuchschema"
command fails in previous versions as well as 9.1. However, I believe that
noninteractive settings (eg, from postgresql.conf or ALTER DATABASE SET)
have always accepted paths including nonexistent schemas. This was felt
to be inconsistent; and also, IIRC, in 9.1 or 9.2 we had made some code
refactorings that made it difficult to sustain such inconsistent behavior.
So we decided to go for the laxer behavior in all cases rather than the
stricter behavior in all cases.
Another rationale for this change was the analogy between search_path
and Unix PATH settings. AFAIK, no Unix-oid platform anywhere will
complain if your PATH mentions a nonexistent directory.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com
Subject: Re: set search_path command
In-Reply-To: <25656.1401750951@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox