public inbox for [email protected]  

help / color / mirror / Atom feed

From: Harry Broomhall <[email protected]>
To: [email protected]
Subject: Re: About SET SEARCH_PATH
Date: Fri, 19 Sep 2003 15:13:10 +0100
Message-ID: <[email protected]> (raw)
References: <[email protected]>
	<[email protected]>

On Wed, 17 Sep 2003 16:40:32 -0400, [email protected] (Tom Lane)
wrote:

>Christoph Haller <[email protected]> writes:
>>> The search path may be altered by a run-time setting.
>>> The command to use is SET SEARCH_PATH 'schema'[,'schema']...
>
>> It should be
>> SET SEARCH_PATH TO schema[,schema]...
>
>Actually, you can do it either way:
>
>regression=# set search_path TO a,b,c;
>regression=# set search_path TO 'a','b','c';
>
>although not
>
>regression=# set search_path TO 'a,b,c';
>ERROR:  schema "a,b,c" does not exist
>

   But surely not without the 'TO' word, which is how it appears in
6.13 of the User's Guide?

   Regards,
          Harry.

view thread (4+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected]
  Subject: Re: About SET SEARCH_PATH
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox