Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitab5fe2a

Browse files
committed
Move pg_settings doc into the right section.
1 parentc7be7ff commitab5fe2a

File tree

2 files changed

+56
-63
lines changed

2 files changed

+56
-63
lines changed

‎doc/src/sgml/catalogs.sgml

Lines changed: 1 addition & 62 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
<!--
22
Documentation of the system catalogs, directed toward PostgreSQL developers
3-
$Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.57 2002/09/02 05:44:43 momjian Exp $
3+
$Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.58 2002/09/02 05:52:34 momjian Exp $
44
-->
55

66
<chapter id="catalogs">
@@ -161,11 +161,6 @@
161161
<entry>database users</entry>
162162
</row>
163163

164-
<row>
165-
<entry>pg_settings</entry>
166-
<entry>current session run-time parameters</entry>
167-
</row>
168-
169164
<row>
170165
<entry>pg_statistic</entry>
171166
<entry>optimizer statistics</entry>
@@ -2871,62 +2866,6 @@
28712866
</sect1>
28722867

28732868

2874-
<sect1 id="catalog-pg-settings">
2875-
<title>pg_settings</title>
2876-
2877-
<para>
2878-
<structname>pg_settings</structname> virtual table allows display and update
2879-
of current session run-time parameters. There is one entry for each of the
2880-
available parameters provided by <command>SHOW ALL</command>. But it is
2881-
in a form that allows it to be joined with other relations and have a
2882-
selection criteria applied.
2883-
</para>
2884-
2885-
<para>
2886-
An <command>UPDATE</command> performed on <structname>pg_settings</structname>
2887-
is equivalent to executing the <command>SET</command> command on that named
2888-
parameter. The change only affects the value used by the current session. If
2889-
an <command>UPDATE</command> is issued within a transaction that is later
2890-
aborted, the effects of the <command>UPDATE</command> command disappear when
2891-
the transaction is rolled back. Once the surrounding transaction is
2892-
committed, the effects will persist until the end of the session, unless
2893-
overridden by another <command>UPDATE</command> or <command>SET</command>.
2894-
</para>
2895-
2896-
<table>
2897-
<title>pg_settings Columns</title>
2898-
2899-
<tgroup cols=4>
2900-
<thead>
2901-
<row>
2902-
<entry>Name</entry>
2903-
<entry>Type</entry>
2904-
<entry>References</entry>
2905-
<entry>Description</entry>
2906-
</row>
2907-
</thead>
2908-
2909-
<tbody>
2910-
<row>
2911-
<entry>name</entry>
2912-
<entry><type>text</type></entry>
2913-
<entry></entry>
2914-
<entry>The name of a current session run-time parameter</entry>
2915-
</row>
2916-
2917-
<row>
2918-
<entry>setting</entry>
2919-
<entry><type>text</type></entry>
2920-
<entry></entry>
2921-
<entry>The value of a current session run-time parameter</entry>
2922-
</row>
2923-
</tbody>
2924-
</tgroup>
2925-
</table>
2926-
2927-
</sect1>
2928-
2929-
29302869
<sect1 id="catalog-pg-statistic">
29312870
<title>pg_statistic</title>
29322871

‎doc/src/sgml/runtime.sgml

Lines changed: 55 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.133 2002/09/02 05:42:54 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.134 2002/09/02 05:52:34 momjian Exp $
33
-->
44

55
<Chapter Id="runtime">
@@ -554,6 +554,60 @@ env PGOPTIONS='-c geqo=off' psql
554554
settings.
555555
</para>
556556

557+
<sect2 id="catalog-pg-settings">
558+
<title>pg_settings</title>
559+
560+
<para>
561+
<structname>pg_settings</structname> virtual table allows display and update
562+
of current session run-time parameters. There is one entry for each of the
563+
available parameters provided by <command>SHOW ALL</command>. But it is
564+
in a form that allows it to be joined with other relations and have a
565+
selection criteria applied.
566+
</para>
567+
568+
<para>
569+
An <command>UPDATE</command> performed on <structname>pg_settings</structname>
570+
is equivalent to executing the <command>SET</command> command on that named
571+
parameter. The change only affects the value used by the current session. If
572+
an <command>UPDATE</command> is issued within a transaction that is later
573+
aborted, the effects of the <command>UPDATE</command> command disappear when
574+
the transaction is rolled back. Once the surrounding transaction is
575+
committed, the effects will persist until the end of the session, unless
576+
overridden by another <command>UPDATE</command> or <command>SET</command>.
577+
</para>
578+
579+
<table>
580+
<title>pg_settings Columns</title>
581+
582+
<tgroup cols=4>
583+
<thead>
584+
<row>
585+
<entry>Name</entry>
586+
<entry>Type</entry>
587+
<entry>References</entry>
588+
<entry>Description</entry>
589+
</row>
590+
</thead>
591+
592+
<tbody>
593+
<row>
594+
<entry>name</entry>
595+
<entry><type>text</type></entry>
596+
<entry></entry>
597+
<entry>The name of a current session run-time parameter</entry>
598+
</row>
599+
600+
<row>
601+
<entry>setting</entry>
602+
<entry><type>text</type></entry>
603+
<entry></entry>
604+
<entry>The value of a current session run-time parameter</entry>
605+
</row>
606+
</tbody>
607+
</tgroup>
608+
609+
</sect2>
610+
557611
<sect2 id="runtime-config-optimizer">
558612
<title>Planner and Optimizer Tuning</title>
559613

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp