From c7be7ffdb0942e2d44d4e7badffe8e70f5aa38eb Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 2 Sep 2002 05:44:43 +0000 Subject: [PATCH] Here is a documentation patch for the pg_settings virtual table. If there are no objections, please apply. Joe Conway --- doc/src/sgml/catalogs.sgml | 63 +++++++++++++++++++++++++++++++++++++- 1 file changed, 62 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index d1f6f9f3ef..b0b3f50f0f 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1,6 +1,6 @@ @@ -161,6 +161,11 @@ database users + + pg_settings + current session run-time parameters + + pg_statistic optimizer statistics @@ -2866,6 +2871,62 @@ + + pg_settings + + + 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 + + + +
+ + + + pg_statistic -- 2.40.0