Re: [DOCS] About SET SEARCH_PATH

[Harry Broomhall]

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.


---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org

Re: [DOCS] About SET SEARCH_PATH

[Tom Lane]

Harry Broomhall <[EMAIL PROTECTED]> writes:
>But surely not without the 'TO' word, which is how it appears in
> 6.13 of the User's Guide?

Right.  I see this is already fixed in the 7.4 docs.

regards, tom lane

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster