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

Commitb5518c8

Browse files
committed
Minor editorial improvements in documentation of session_replication_role;
in particular correct the obsolete claim that it can't be changed onceany plans have been cached.
1 parent6322e84 commitb5518c8

File tree

3 files changed

+22
-21
lines changed

3 files changed

+22
-21
lines changed

‎doc/src/sgml/config.sgml

Lines changed: 19 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.161 2008/01/21 03:28:42 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.162 2008/01/27 19:12:28 tgl Exp $ -->
22

33
<chapter Id="runtime-config">
44
<title>Server Configuration</title>
@@ -3841,6 +3841,24 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
38413841
</listitem>
38423842
</varlistentry>
38433843

3844+
<varlistentry id="guc-session-replication-role" xreflabel="session_replication_role">
3845+
<term><varname>session_replication_role</varname> (<type>string</type>)</term>
3846+
<indexterm>
3847+
<primary><varname>session_replication_role</> configuration parameter</primary>
3848+
</indexterm>
3849+
<listitem>
3850+
<para>
3851+
Controls firing of replication-related triggers and rules for the
3852+
current session. Setting this variable requires
3853+
superuser privilege and results in discarding any previously cached
3854+
query plans. Possible values are <literal>origin</> (the default),
3855+
<literal>replica</> and <literal>local</>.
3856+
See <xref linkend="sql-altertable" endterm="sql-altertable-title"> for
3857+
more information.
3858+
</para>
3859+
</listitem>
3860+
</varlistentry>
3861+
38443862
<varlistentry id="guc-statement-timeout" xreflabel="statement_timeout">
38453863
<term><varname>statement_timeout</varname> (<type>integer</type>)</term>
38463864
<indexterm>
@@ -3858,23 +3876,6 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
38583876
</listitem>
38593877
</varlistentry>
38603878

3861-
<varlistentry id="guc-session-replication-role" xreflabel="session_replication_role">
3862-
<term><varname>session_replication_role</varname> (<type>string</type>)</term>
3863-
<indexterm>
3864-
<primary><varname>session_replication_role</> configuration parameter</primary>
3865-
</indexterm>
3866-
<listitem>
3867-
<para>
3868-
Controls the trigger and rule firing for the current session.
3869-
See <xref linkend="sql-altertable" endterm="sql-altertable-title"> for the different options to
3870-
enable or disable triggers and rules. Setting the variable requires
3871-
superuser privilege and can only be done before any query plans have
3872-
been cached. Possible values are <literal>origin</>,
3873-
<literal>replica</> and <literal>local</>.
3874-
</para>
3875-
</listitem>
3876-
</varlistentry>
3877-
38783879
<varlistentry id="guc-vacuum-freeze-min-age" xreflabel="vacuum_freeze_min_age">
38793880
<term><varname>vacuum_freeze_min_age</varname> (<type>integer</type>)</term>
38803881
<indexterm>

‎src/backend/utils/misc/guc.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
* Written by Peter Eisentraut <peter_e@gmx.net>.
1111
*
1212
* IDENTIFICATION
13-
* $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.430 2008/01/14 19:18:53 tgl Exp $
13+
* $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.431 2008/01/27 19:12:28 tgl Exp $
1414
*
1515
*--------------------------------------------------------------------
1616
*/
@@ -2022,7 +2022,7 @@ static struct config_string ConfigureNamesString[] =
20222022

20232023
{
20242024
{"session_replication_role",PGC_SUSET,CLIENT_CONN_STATEMENT,
2025-
gettext_noop("Sets thesessions behavior for triggers and rewrite rules."),
2025+
gettext_noop("Sets thesession's behavior for triggers and rewrite rules."),
20262026
gettext_noop("Each session can be either"
20272027
" \"origin\", \"replica\", or \"local\".")
20282028
},

‎src/backend/utils/misc/postgresql.conf.sample

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -414,8 +414,8 @@
414414
#check_function_bodies = on
415415
#default_transaction_isolation = 'read committed'
416416
#default_transaction_read_only = off
417+
#session_replication_role = 'origin'
417418
#statement_timeout = 0# 0 is disabled
418-
#session_replication_role = "origin"
419419
#vacuum_freeze_min_age = 100000000
420420
#xmlbinary = 'base64'
421421
#xmloption = 'content'

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp