From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Add cross-references re schema search path |
Date: | 2002-08-20 20:07:54 |
Message-ID: | 200208202007.g7KK7te20099@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Oliver Elphick wrote:
> I had great difficulty in finding how to change the search path, so here
> is a patch to add some cross-referencing.
>
> --
> Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)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.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">
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-08-20 21:20:56 | Re: Add cross-references re schema search path |
Previous Message | Oliver Elphick | 2002-08-20 05:49:45 | Add cross-references re schema search path |