Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 6E0D2475A2E
	for <pgsql-docs@postgresql.org>; Thu, 22 Aug 2002 00:52:11 -0400 (EDT)
Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net
	[216.55.132.35])
	by postgresql.org (Postfix) with ESMTP id 77E8647580E
	for <pgsql-docs@postgresql.org>; Thu, 22 Aug 2002 00:52:08 -0400 (EDT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.10.1) id g7M4q4F07903;
	Thu, 22 Aug 2002 00:52:04 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200208220452.g7M4q4F07903@candle.pha.pa.us>
Subject: Re: Add cross-references re schema search path
In-Reply-To: <1029966919.31594.1705.camel@linda>
To: Oliver Elphick <olly@lfix.co.uk>
Date: Thu, 22 Aug 2002 00:52:04 -0400 (EDT)
Cc: Peter Eisentraut <peter_e@gmx.net>, pgsql-docs@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL99 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/21
X-Sequence-Number: 1439


Patch applied.  Thanks.

---------------------------------------------------------------------------


Oliver Elphick wrote:
> On Tue, 2002-08-20 at 22:20, Peter Eisentraut wrote:
> > Oliver Elphick writes:
> > 
> > > I had great difficulty in finding how to change the search path, so here
> > > is a patch to add some cross-referencing.
> > 
> > You can't link across books.  They need to build separately.
> 
> Here's a replacement patch.
>   
> -- 
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight, UK                            
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>                  ========================================
>      "But I would not have you to be ignorant, brethren, 
>       concerning them which are asleep, that ye sorrow not, 
>       even as others which have no hope. For if we believe 
>       that Jesus died and rose again, even so them also 
>       which sleep in Jesus will God bring with him."        
>                                 I Thessalonians 4:13,14 

[ text/x-patch is unsupported, treating like TEXT/PLAIN ]

> Index: doc/src/sgml/func.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
> retrieving revision 1.115
> diff -u -r1.115 func.sgml
> --- doc/src/sgml/func.sgml	2002/08/21 16:08:19	1.115
> +++ doc/src/sgml/func.sgml	2002/08/21 21:47:19
> @@ -5144,6 +5144,17 @@
>      path returned.
>     </para>
>  
> +   <para id=set-search-path xreflabel="SET SEARCH_PATH">
> +    <indexterm>
> +     <primary>search path</primary>
> +     <secondary>changing at runtime</secondary>
> +    </indexterm>
> +    The search path may be altered by a runtime-alterable GUC setting.  The
> +    command to use is <command>
> +     SET SEARCH_PATH '<varname>schema</varname>'[,'<varname>schema</varname>']...
> +    </command>
> +   </para>
> +
>     <table>
>      <title>System Information Functions</title>
>      <tgroup cols="3">
> Index: doc/src/sgml/runtime.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/runtime.sgml,v
> retrieving revision 1.126
> diff -u -r1.126 runtime.sgml
> --- doc/src/sgml/runtime.sgml	2002/08/18 03:03:25	1.126
> +++ doc/src/sgml/runtime.sgml	2002/08/21 21:47:23
> @@ -1608,6 +1608,10 @@
>         </para>
>  
>         <para>
> +	 <indexterm>
> +	  <primary>schemas</primary>
> +	  <secondary>current schema</secondary>
> +	 </indexterm>
>          The current effective value of the search path can be examined
>  	via the SQL function <function>current_schemas()</>.  This is not
>  	quite the same as examining the value of
> Index: doc/src/sgml/syntax.sgml
> ===================================================================
> RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/syntax.sgml,v
> retrieving revision 1.66
> diff -u -r1.66 syntax.sgml
> --- doc/src/sgml/syntax.sgml	2002/08/13 20:40:43	1.66
> +++ doc/src/sgml/syntax.sgml	2002/08/21 21:47:37
> @@ -965,6 +965,11 @@
>      place <literal>pg_catalog</> at the end of your search path if you
>      prefer to have user-defined names override built-in names.
>     </para>
> +
> +    <para>
> +     The search path is determined by the GUC variable SEARCH_PATH and
> +     may be changed at any time.  See <xref linkend="set-search-path">.
> +    </para>
>    </sect2>
>  
>    <sect2 id="sql-reserved-names">

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073