public inbox for [email protected]
help / color / mirror / Atom feedFrom: Oliver Elphick <[email protected]>
To: [email protected]
Subject: Add cross-references re schema search path
Date: 20 Aug 2002 06:49:45 +0100
Message-ID: <1029822586.19817.69.camel@linda> (raw)
I had great difficulty in finding how to change the search path, so here
is a patch to add some cross-referencing.
--
Oliver Elphick [email protected]
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
Attachments:
[text/x-patch] pgsql.doc.patch (2.2K, 2-pgsql.doc.patch)
download | inline diff:
Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.112
diff -u -r1.112 func.sgml
--- doc/src/sgml/func.sgml 2002/08/16 23:01:18 1.112
+++ doc/src/sgml/func.sgml 2002/08/19 04:15:18
@@ -5139,6 +5139,11 @@
path returned.
</para>
+ <para>
+ The search path may be altered by a runtime-alterable GUC setting:
+ <xref linkend="set-search-path">.
+ </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/19 04:15:23
@@ -1548,7 +1548,7 @@
</listitem>
</varlistentry>
- <varlistentry>
+ <varlistentry id="set-search-path" xreflabel="SET SEARCH_PATH">
<term><varname>SEARCH_PATH</varname> (<type>string</type>)</term>
<indexterm><primary>search_path</></>
<indexterm><primary>namespaces</></>
@@ -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/19 04:15:36
@@ -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">
view thread (7+ 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: Add cross-references re schema search path
In-Reply-To: <1029822586.19817.69.camel@linda>
* 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