Content-Length: 276040 | pFad | http://github.com/postgrespro/postgres/commit/961cf5c9055ff5f689a06aafed3346146b3cee43

2E Doc: Update the logical replication restriction w.r.t Replica Identit… · postgrespro/postgres@961cf5c · GitHub
Skip to content

Commit 961cf5c

Browse files
author
Amit Kapila
committed
Doc: Update the logical replication restriction w.r.t Replica Identity Full.
Author: Kuroda Hayato Reviewed-by: Peter Smith, Onder Kalaci, Sergei Kornilov, Amit Kapila Discussion: https://postgr.es/m/TYAPR01MB58662174ED62648E0D611194F530A@TYAPR01MB5866.jpnprd01.prod.outlook.com
1 parent 137b131 commit 961cf5c

File tree

1 file changed

+13
-0
lines changed

1 file changed

+13
-0
lines changed

doc/src/sgml/logical-replication.sgml

Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1622,6 +1622,19 @@ CONTEXT: processing remote data for replication origen "pg_16395" during "INSER
16221622
parameter of <command>CREATE PUBLICATION</command>).
16231623
</para>
16241624
</listitem>
1625+
1626+
<listitem>
1627+
<para>
1628+
When using
1629+
<link linkend="sql-altertable-replica-identity-full"><literal>REPLICA IDENTITY FULL</literal></link>
1630+
on published tables, it is important to note that the <literal>UPDATE</literal>
1631+
and <literal>DELETE</literal> operations cannot be applied to subscribers
1632+
if the tables include attributes with datatypes (such as point or box)
1633+
that do not have a default operator class for B-tree or Hash. However,
1634+
this limitation can be overcome by ensuring that the table has a primary
1635+
key or replica identity defined for it.
1636+
</para>
1637+
</listitem>
16251638
</itemizedlist>
16261639
</sect1>
16271640

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/961cf5c9055ff5f689a06aafed3346146b3cee43

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy