Re: show() function - updated patch

Later version of patch applied.  Thanks.

---------------------------------------------------------------------------


Joe Conway wrote:
> Tom Lane wrote:
> > This patch is lacking documentation additions for the newly-defined
> > functions; not to mention doc updates for the new behavior of SHOW.
> > Please supply...
>
> Here is a doc patch for the SHOW X changes and new config-settings
> functions. If there are no objections, please apply.
>
> Thanks,
>
> Joe

> Index: doc/src/sgml/ref/show.sgml
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/doc/src/sgml/ref/show.sgml,v
> retrieving revision 1.17
> diff -c -r1.17 show.sgml
> *** doc/src/sgml/ref/show.sgml    17 May 2002 01:19:16 -0000    1.17
> --- doc/src/sgml/ref/show.sgml    20 Jul 2002 16:54:21 -0000
> ***************
> *** 83,89 ****
>
>   <screen>
>   SHOW DateStyle;
> ! INFO:  DateStyle is ISO with US (NonEuropean) conventions
>   </screen>
>     </para>
>
> --- 83,92 ----
>
>   <screen>
>   SHOW DateStyle;
> !                DateStyle
> ! ---------------------------------------
> !  ISO with US (NonEuropean) conventions
> ! (1 row)
>   </screen>
>     </para>
>
> ***************
> *** 91,99 ****
>      Show the current genetic optimizer (<literal>geqo</literal>) setting:
>   <screen>
>   SHOW GEQO;
> ! INFO:  geqo is on
>   </screen>
>     </para>
>    </refsect1>
>
>    <refsect1 id="R1-SQL-SHOW-3">
> --- 94,125 ----
>      Show the current genetic optimizer (<literal>geqo</literal>) setting:
>   <screen>
>   SHOW GEQO;
> !  geqo
> ! ------
> !  on
> ! (1 row)
>   </screen>
>     </para>
> +
> +   <para>
> +    Show all settings:
> + <screen>
> + SHOW ALL;
> +              name              |                setting
> + -------------------------------+---------------------------------------
> +  australian_timezones          | off
> +  authentication_timeout        | 60
> +  checkpoint_segments           | 3
> +     .
> +     .
> +     .
> +  wal_debug                     | 0
> +  wal_files                     | 0
> +  wal_sync_method               | fdatasync
> + (94 rows)
> + </screen>
> +   </para>
> +
>    </refsect1>
>
>    <refsect1 id="R1-SQL-SHOW-3">
> Index: doc/src/sgml/func.sgml
> ===================================================================
> RCS file: /opt/src/cvs/pgsql/doc/src/sgml/func.sgml,v
> retrieving revision 1.104
> diff -c -r1.104 func.sgml
> *** doc/src/sgml/func.sgml    24 Jun 2002 22:17:01 -0000    1.104
> --- doc/src/sgml/func.sgml    20 Jul 2002 20:34:04 -0000
> ***************
> *** 4437,4442 ****
> --- 4437,4555 ----
>      </para>
>
>      <table>
> +     <title>Configuration Settings Information Functions</title>
> +     <tgroup cols="3">
> +      <thead>
> +       <row><entry>Name</entry> <entry>Return Type</entry> <entry>Description</entry></row>
> +      </thead>
> +
> +      <tbody>
> +       <row>
> +        <entry>
> +         <function>current_setting</function>(<parameter>setting_name</parameter>)
> +        </entry>
> +        <entry><type>text</type></entry>
> +        <entry>value of current setting</entry>
> +       </row>
> +       <row>
> +        <entry>
> +         <function>set_config(<parameter>setting_name</parameter>,
> +                              <parameter>new_value</parameter>,
> +                              <parameter>is_local</parameter>)</function>
> +        </entry>
> +        <entry><type>text</type></entry>
> +        <entry>new value of current setting</entry>
> +       </row>
> +      </tbody>
> +     </tgroup>
> +    </table>
> +
> +    <indexterm zone="functions-misc">
> +     <primary>setting</primary>
> +     <secondary>current</secondary>
> +    </indexterm>
> +
> +    <indexterm zone="functions-misc">
> +     <primary>setting</primary>
> +     <secondary>set</secondary>
> +    </indexterm>
> +
> +    <para>
> +     The <function>current_setting</function> is used to obtain the current
> +     value of the <parameter>setting_name</parameter> setting, as a query
> +     result. For example:
> + <programlisting>
> + select current_setting('DateStyle');
> +             current_setting
> + ---------------------------------------
> +  ISO with US (NonEuropean) conventions
> + (1 row)
> + </programlisting>
> +    </para>
> +
> +    <para>
> +     <function>set_config</function> allows the <parameter>setting_name
> +     </parameter> setting to be changed to <parameter>new_value</parameter>.
> +     If <parameter>is_local</parameter> is set to <literal>true</literal>,
> +     the new value will only apply to the current transaction. If you want
> +     the new value to apply for the current session, use <literal>false</literal>
> +     instead. For example:
> + <programlisting>
> + SHOW show_query_stats;
> +  show_query_stats
> + ------------------
> +  on
> + (1 row)
> +
> + select set_config('show_query_stats','off','f');
> +  set_config
> + ------------
> +  off
> + (1 row)
> +
> + SHOW show_query_stats;
> +  show_query_stats
> + ------------------
> +  off
> + (1 row)
> +
> + select set_config('show_query_stats','on','t');
> +  set_config
> + ------------
> +  on
> + (1 row)
> +
> + SHOW show_query_stats;
> +  show_query_stats
> + ------------------
> +  off
> + (1 row)
> +
> + BEGIN;
> + BEGIN
> + select set_config('show_query_stats','on','t');
> +  set_config
> + ------------
> +  on
> + (1 row)
> +
> + SHOW show_query_stats;
> +  show_query_stats
> + ------------------
> +  on
> + (1 row)
> +
> + COMMIT;
> + COMMIT
> + SHOW show_query_stats;
> +  show_query_stats
> + ------------------
> +  off
> + (1 row)
> + </programlisting>
> +    </para>
> +
> +    <table>
>       <title>Access Privilege Inquiry Functions</title>
>       <tgroup cols="3">
>        <thead>

>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026