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

Commitd8209d0

Browse files
committed
Rework <warning> box about column list combining in logical replication
After some copy-edit I made in commit3a06a79, we have a <sect2>that only contains a warning box. This doesn't look good. Rework bymoving the sect2 title to be the warning's title, and put the 'id' to itas well, so that the external reference continues to work.Backpatch to 15.In branch master, I also take the opportunity to add titles to a coupleof other warning boxes elsewhere in the documentation.Discussion:https://postgr.es/m/20221219164713.ccnlvtkyj6lmshqq@alvherre.pgsql
1 parent5436cb3 commitd8209d0

File tree

1 file changed

+20
-16
lines changed

1 file changed

+20
-16
lines changed

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

Lines changed: 20 additions & 16 deletions
Original file line numberDiff line numberDiff line change
@@ -1153,26 +1153,30 @@ test_sub=# SELECT * FROM child ORDER BY a;
11531153
ignoring any column lists.
11541154
</para>
11551155

1156-
<sect2 id="logical-replication-col-list-combining">
1157-
<title>Combining Multiple Column Lists</title>
1158-
1159-
<warning>
1156+
<warning id="logical-replication-col-list-combining">
1157+
<title>Warning: Combining Column Lists from Multiple Publications</title>
1158+
<para>
1159+
There's currently no support for subscriptions comprising several
1160+
publications where the same table has been published with different
1161+
column lists. <xref linkend="sql-createsubscription"/> disallows
1162+
creating such subscriptions, but it is still possible to get into
1163+
that situation by adding or altering column lists on the publication
1164+
side after a subscription has been created.
1165+
</para>
11601166
<para>
1161-
It is not supported to have a subscription comprising severalpublications
1162-
where the same table has been published with different column lists.
1163-
This means changing the column lists of the tables being subscribed could
1164-
cause inconsistency of column lists among publications, in which case
1165-
the <xref linkend="sql-alterpublication"/> will be successful but later
1166-
the walsender on the publisher, or the subscriber may throw an error. In
1167-
this scenario, the user needs to recreatethesubscription after adjusting
1168-
the column list or drop the problematic publication using
1169-
<literal>ALTER SUBSCRIPTION ... DROP PUBLICATION</literal>and then add it
1170-
back after adjusting thecolumn list.
1167+
This means changing the column lists of tables onpublications that are
1168+
already subscribed could lead to errors being thrown on the subscriber
1169+
side.
1170+
</para>
1171+
<para>
1172+
If a subscription is affected by this problem, the only way to resume
1173+
replication is to adjust one ofthecolumn lists on the publication
1174+
side so that they all match; and then either recreate the subscription,
1175+
or use<literal>ALTER SUBSCRIPTION ... DROP PUBLICATION</literal>to
1176+
remove one of theoffending publications and add it again.
11711177
</para>
11721178
</warning>
11731179

1174-
</sect2>
1175-
11761180
<sect2 id="logical-replication-col-list-examples">
11771181
<title>Examples</title>
11781182

0 commit comments

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