public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Oliver Elphick <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: [email protected]
Subject: Re: Add cross-references re schema search path
Date: Thu, 22 Aug 2002 00:52:04 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <1029966919.31594.1705.camel@linda>
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 [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
[ 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 [email protected] so that your
> message can get through to the mailing list cleanly
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
view thread (7+ messages)
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], [email protected], [email protected]
Subject: Re: Add cross-references re schema 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