|
|
pg_settings doc patch: msg#00647
|
Subject: |
pg_settings doc patch |
Here is a documentation patch for the pg_settings virtual table. If
there are no objections, please apply.
Thanks,
Joe
Index: doc/src/sgml/catalogs.sgml
===================================================================
RCS file: /opt/src/cvs/pgsql-server/doc/src/sgml/catalogs.sgml,v
retrieving revision 2.56
diff -c -r2.56 catalogs.sgml
*** doc/src/sgml/catalogs.sgml 30 Aug 2002 19:23:18 -0000 2.56
--- doc/src/sgml/catalogs.sgml 31 Aug 2002 22:46:02 -0000
***************
*** 162,167 ****
--- 162,172 ----
+ pg_settings
+ current session run-time parameters
+
+
+
pg_statistic
optimizer statistics
***************
*** 2858,2863 ****
--- 2863,2924 ----
text[]
Session defaults for run-time configuration variables
+
+
+
+ |
+
+
+
+
+
+
+
+
+ pg_settings virtual table allows display and update
+ of current session run-time parameters. There is one entry for each of the
+ available parameters provided by SHOW ALL. But it is
+ in a form that allows it to be joined with other relations and have a
+ selection criteria applied.
+
+
+
+ An UPDATE performed on pg_settings
+ is equivalent to executing the SET command on that named
+ parameter. The change only affects the value used by the current session. If
+ an UPDATE is issued within a transaction that is later
+ aborted, the effects of the UPDATE command disappear when
+ the transaction is rolled back. Once the surrounding transaction is
+ committed, the effects will persist until the end of the session, unless
+ overridden by another UPDATE or SET.
+
+
+
+ pg_settings Columns
+
+
+
+
+ Name
+ Type
+ References
+ Description
+
+
+
+
+
+ name
+ text
+
+ The name of a current session run-time parameter
+
+
+
+ setting
+ text
+
+ The value of a current session run-time parameter
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
| |
