Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2D09A475B64
	for <pgsql-docs@postgresql.org>; Wed, 21 Aug 2002 17:55:28 -0400 (EDT)
Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net
	[194.217.242.90])
	by postgresql.org (Postfix) with ESMTP id 71BB4475974
	for <pgsql-docs@postgresql.org>; Wed, 21 Aug 2002 17:55:27 -0400 (EDT)
Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk)
	by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1)
	id 17hdRf-000Kms-0W; Wed, 21 Aug 2002 22:55:20 +0100
Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly)
	by linda.lfix.co.uk with esmtp (Exim 3.35 #1 (Debian))
	id 17hdRf-0007e4-00; Wed, 21 Aug 2002 22:55:19 +0100
Subject: Re: Add cross-references re schema search path
From: Oliver Elphick <olly@lfix.co.uk>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-docs@postgresql.org, Bruce Momjian <pgman@candle.pha.pa.us>
In-Reply-To: <Pine.LNX.4.44.0208202015260.2327-100000@localhost.localdomain>
References: <Pine.LNX.4.44.0208202015260.2327-100000@localhost.localdomain>
Content-Type: multipart/mixed; boundary="=-gaUj1+gKFdn9h0cAFY9Q"
X-Mailer: Ximian Evolution 1.0.8 
Date: 21 Aug 2002 22:55:18 +0100
Message-Id: <1029966919.31594.1705.camel@linda>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/18
X-Sequence-Number: 1436

--=-gaUj1+gKFdn9h0cAFY9Q
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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 

--=-gaUj1+gKFdn9h0cAFY9Q
Content-Disposition: inline; filename=pgsql.doc.patch
Content-Transfer-Encoding: quoted-printable
Content-Type: text/x-patch; name=pgsql.doc.patch; charset=ISO-8859-15

Index: doc/src/sgml/func.sgml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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>
=20
+   <para id=3Dset-search-path xreflabel=3D"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</varnam=
e>']...
+    </command>
+   </para>
+
    <table>
     <title>System Information Functions</title>
     <tgroup cols=3D"3">
Index: doc/src/sgml/runtime.sgml
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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>
=20
        <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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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=3D"set-search-path">.
+    </para>
   </sect2>
=20
   <sect2 id=3D"sql-reserved-names">

--=-gaUj1+gKFdn9h0cAFY9Q--