diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-01-27 19:12:28 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-01-27 19:12:28 +0000 |
commit | b5518c8e886758800576ebf74eaa525eb3aa5550 (patch) | |
tree | d3ed9bd58c3b1eb20eb731371865981c1f13c167 | |
parent | 6322e84430e2b1756fbf31072679507266f2b304 (diff) | |
download | postgresql-b5518c8e886758800576ebf74eaa525eb3aa5550.tar.gz postgresql-b5518c8e886758800576ebf74eaa525eb3aa5550.zip |
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.
-rw-r--r-- | doc/src/sgml/config.sgml | 37 | ||||
-rw-r--r-- | src/backend/utils/misc/guc.c | 4 | ||||
-rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 2 |
3 files changed, 22 insertions, 21 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index a64dabfd058..30ca1c219c9 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.161 2008/01/21 03:28:42 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.162 2008/01/27 19:12:28 tgl Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -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 8e5667ffb77..e3e04f4d341 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.430 2008/01/14 19:18:53 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.431 2008/01/27 19:12:28 tgl Exp $ * *-------------------------------------------------------------------- */ @@ -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 022ffe57ae8..d9b9532395e 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' |