Re: Add cross-references re schema search path
От | Bruce Momjian |
---|---|
Тема | Re: Add cross-references re schema search path |
Дата | |
Msg-id | 200208220452.g7M4q4F07903@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Add cross-references re schema search path (Oliver Elphick <olly@lfix.co.uk>) |
Список | 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
В списке pgsql-docs по дате отправления: