From 7938874f89bfd3c44fd362b89eaca53c1da1c4ef Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Sun, 27 Jan 2008 19:12:28 +0000
Subject: [PATCH] Minor editorial improvements in documentation of
 session_replication_role; in particular correct the obsolete claim that it
 can't be changed once any plans have been cached.

---
 doc/src/sgml/config.sgml                      | 35 ++++++++++---------
 src/backend/utils/misc/guc.c                  |  2 +-
 src/backend/utils/misc/postgresql.conf.sample |  2 +-
 3 files changed, 20 insertions(+), 19 deletions(-)

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index b41b585b27..aab39d1ced 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -3841,6 +3841,24 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
       </listitem>
      </varlistentry>
 
+     <varlistentry id="guc-session-replication-role" xreflabel="session_replication_role">
+      <term><varname>session_replication_role</varname> (<type>string</type>)</term>
+      <indexterm>
+       <primary><varname>session_replication_role</> configuration parameter</primary>
+      </indexterm>
+      <listitem>
+       <para>
+        Controls firing of replication-related triggers and rules for the
+        current session.  Setting this variable requires
+        superuser privilege and results in discarding any previously cached
+        query plans.  Possible values are <literal>origin</> (the default),
+        <literal>replica</> and <literal>local</>.
+        See <xref linkend="sql-altertable" endterm="sql-altertable-title"> for
+        more information.
+       </para>
+      </listitem>
+     </varlistentry>
+
      <varlistentry id="guc-statement-timeout" xreflabel="statement_timeout">
       <term><varname>statement_timeout</varname> (<type>integer</type>)</term>
       <indexterm>
@@ -3858,23 +3876,6 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
       </listitem>
      </varlistentry>
 
-     <varlistentry id="guc-session-replication-role" xreflabel="session_replication_role">
-      <term><varname>session_replication_role</varname> (<type>string</type>)</term>
-      <indexterm>
-       <primary><varname>session_replication_role</> configuration parameter</primary>
-      </indexterm>
-      <listitem>
-       <para>
-        Controls the trigger and rule firing for the current session.
-        See <xref linkend="sql-altertable" endterm="sql-altertable-title"> for the different options to
-        enable or disable triggers and rules. Setting the variable requires
-        superuser privilege and can only be done before any query plans have
-        been cached. Possible values are <literal>origin</>,
-        <literal>replica</> and <literal>local</>.
-       </para>
-      </listitem>
-     </varlistentry>
-
      <varlistentry id="guc-vacuum-freeze-min-age" xreflabel="vacuum_freeze_min_age">
       <term><varname>vacuum_freeze_min_age</varname> (<type>integer</type>)</term>
       <indexterm>
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c
index acd0900d96..954f113660 100644
--- a/src/backend/utils/misc/guc.c
+++ b/src/backend/utils/misc/guc.c
@@ -2022,7 +2022,7 @@ static struct config_string ConfigureNamesString[] =
 
 	{
 		{"session_replication_role", PGC_SUSET, CLIENT_CONN_STATEMENT,
-			gettext_noop("Sets the sessions behavior for triggers and rewrite rules."),
+			gettext_noop("Sets the session's behavior for triggers and rewrite rules."),
 			gettext_noop("Each session can be either"
 						 " \"origin\", \"replica\", or \"local\".")
 		},
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
index 022ffe57ae..d9b9532395 100644
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -414,8 +414,8 @@
 #check_function_bodies = on
 #default_transaction_isolation = 'read committed'
 #default_transaction_read_only = off
+#session_replication_role = 'origin'
 #statement_timeout = 0			# 0 is disabled
-#session_replication_role = "origin"
 #vacuum_freeze_min_age = 100000000
 #xmlbinary = 'base64'
 #xmloption = 'content'
-- 
2.39.5