File tree Expand file tree Collapse file tree 1 file changed +11
-5
lines changed Expand file tree Collapse file tree 1 file changed +11
-5
lines changed Original file line number Diff line number Diff line change @@ -722,16 +722,18 @@ OutputPluginWrite(ctx, true);
722
722
723
723
<para>
724
724
In synchronous replication setup, a deadlock can happen, if the transaction
725
- has locked [user] catalog tables exclusively. This is because logical decoding of
726
- transactions can lock catalog tables to access them. To avoid this users
727
- must refrain from taking an exclusive lock on [user] catalog tables. This can
728
- happen in the following ways:
725
+ has locked [user] catalog tables exclusively. See
726
+ <xref linkend="logicaldecoding-capabilities"> for information on user
727
+ catalog tables. This is because logical decoding of transactions can lock
728
+ catalog tables to access them. To avoid this users must refrain from taking
729
+ an exclusive lock on [user] catalog tables. This can happen in the following
730
+ ways:
729
731
730
732
<itemizedlist>
731
733
<listitem>
732
734
<para>
733
735
Issuing an explicit <command>LOCK</command> on <structname>pg_class</structname>
734
- (or any other catalog table) in a transaction.
736
+ in a transaction.
735
737
</para>
736
738
</listitem>
737
739
@@ -749,6 +751,10 @@ OutputPluginWrite(ctx, true);
749
751
</para>
750
752
</listitem>
751
753
</itemizedlist>
754
+
755
+ Note that these commands that can cause deadlock apply to not only explicitly
756
+ indicated system catalog tables above but also to any other [user] catalog
757
+ table.
752
758
</para>
753
759
</sect2>
754
760
</sect1>
You can’t perform that action at this time.
0 commit comments