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

Commit8aac614

Browse files
author
Amit Kapila
committed
Doc: Clarify the behavior of triggers/rules in a logical subscriber.
By default, triggers and rules do not fire on a logical replicationsubscriber based on the "session_replication_role" GUC being set to"replica". However, the docs in the logical replication section assumedthat the reader understood how this GUC worked. This modifies the docs tobe more explicit and links back to the GUC itself.Author: Jonathan Katz, Peter SmithReviewed-by: Vignesh C, Euler TaveiraBackpatch-through: 11Discussion:https://postgr.es/m/5bb2c9a2-499f-e1a2-6e33-5ce96b35cc4a@postgresql.org
1 parent4e17cb0 commit8aac614

File tree

1 file changed

+7
-3
lines changed

1 file changed

+7
-3
lines changed

‎doc/src/sgml/logical-replication.sgml

Lines changed: 7 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1462,9 +1462,13 @@ CONTEXT: processing remote data for replication origin "pg_16395" during "INSER
14621462

14631463
<para>
14641464
The apply process on the subscriber database always runs with
1465-
<varname>session_replication_role</varname> set
1466-
to <literal>replica</literal>, which produces the usual effects on triggers
1467-
and constraints.
1465+
<link linkend="guc-session-replication-role"><varname>session_replication_role</varname></link>
1466+
set to <literal>replica</literal>. This means that, by default,
1467+
triggers and rules will not fire on a subscriber. Users can optionally choose to
1468+
enable triggers and rules on a table using the
1469+
<link linkend="sql-altertable"><command>ALTER TABLE</command></link> command
1470+
and the <literal>ENABLE TRIGGER</literal> and <literal>ENABLE RULE</literal>
1471+
clauses.
14681472
</para>
14691473

14701474
<para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp