pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedAdd cross-references re schema search path
7+ messages / 3 participants
[nested] [flat]
* Add cross-references re schema search path
@ 2002-08-20 05:49 Oliver Elphick <olly@lfix.co.uk>
0 siblings, 2 replies; 7+ messages in thread
From: Oliver Elphick @ 2002-08-20 05:49 UTC (permalink / raw)
To: pgsql-docs
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.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
Attachments:
pgsql.doc.patch (text/x-patch, 2.2K) download
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">
* Re: Add cross-references re schema search path
@ 2002-08-20 20:07 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Oliver Elphick <olly@lfix.co.uk>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2002-08-20 20:07 UTC (permalink / raw)
To: Oliver Elphick <olly@lfix.co.uk>; +Cc: 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.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.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@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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Add cross-references re schema search path
@ 2002-08-20 21:20 Peter Eisentraut <peter_e@gmx.net>
parent: Oliver Elphick <olly@lfix.co.uk>
1 sibling, 2 replies; 7+ messages in thread
From: Peter Eisentraut @ 2002-08-20 21:20 UTC (permalink / raw)
To: Oliver Elphick <olly@lfix.co.uk>; +Cc: pgsql-docs
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.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Add cross-references re schema search path
@ 2002-08-20 21:24 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2002-08-20 21:24 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Oliver Elphick <olly@lfix.co.uk>; pgsql-docs
OK, I will remove the reference to:
+ <varlistentry id="set-search-path" xreflabel="SET SEARCH_PATH">
^^^^^^^^^^^^^^^^^^^^^^^^^^
---------------------------------------------------------------------------
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.
>
> --
> Peter Eisentraut peter_e@gmx.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Add cross-references re schema search path
@ 2002-08-21 21:55 Oliver Elphick <olly@lfix.co.uk>
parent: Peter Eisentraut <peter_e@gmx.net>
1 sibling, 2 replies; 7+ messages in thread
From: Oliver Elphick @ 2002-08-21 21:55 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-docs@postgresql.org, Bruce Momjian <pgman@candle.pha.pa.us>
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
Attachments:
pgsql.doc.patch (text/x-patch, 2.2K) download
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">
* Re: Add cross-references re schema search path
@ 2002-08-21 22:04 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Oliver Elphick <olly@lfix.co.uk>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2002-08-21 22:04 UTC (permalink / raw)
To: Oliver Elphick <olly@lfix.co.uk>; +Cc: Peter Eisentraut <peter_e@gmx.net>; 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:
> 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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Add cross-references re schema search path
@ 2002-08-22 04:52 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Oliver Elphick <olly@lfix.co.uk>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2002-08-22 04:52 UTC (permalink / raw)
To: Oliver Elphick <olly@lfix.co.uk>; +Cc: Peter Eisentraut <peter_e@gmx.net>; pgsql-docs
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
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2002-08-22 04:52 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-20 05:49 Add cross-references re schema search path Oliver Elphick <olly@lfix.co.uk>
2002-08-20 20:07 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-08-20 21:20 ` Peter Eisentraut <peter_e@gmx.net>
2002-08-20 21:24 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-08-21 21:55 ` Oliver Elphick <olly@lfix.co.uk>
2002-08-21 22:04 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-08-22 04:52 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox