]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix partition table's REPLICA IDENTITY checking on the subscriber.
authorAmit Kapila <akapila@postgresql.org>
Tue, 21 Jun 2022 02:22:41 +0000 (07:52 +0530)
committerAmit Kapila <akapila@postgresql.org>
Tue, 21 Jun 2022 02:33:30 +0000 (08:03 +0530)
commit52d5ea9adb010d0908e8962842571cd1f6c2d66c
tree4ad10244f26736df90d386db8f1d9bf74d8effbb
parent0980adfd4d021e3329bf41452ce1a1210321974f
Fix partition table's REPLICA IDENTITY checking on the subscriber.

In logical replication, we will check if the target table on the
subscriber is updatable by comparing the replica identity of the table on
the publisher with the table on the subscriber. When the target table is a
partitioned table, we only check its replica identity but not for the
partition tables. This leads to assertion failure while applying changes
for update/delete as we expect those to succeed only when the
corresponding partition table has a primary key or has a replica
identity defined.

Fix it by checking the replica identity of the partition table while
applying changes.

Reported-by: Shi Yu
Author: Shi Yu, Hou Zhijie
Reviewed-by: Amit Langote, Amit Kapila
Backpatch-through: 13, where it was introduced
Discussion: https://postgr.es/m/OSZPR01MB6310F46CD425A967E4AEF736FDA49@OSZPR01MB6310.jpnprd01.prod.outlook.com
src/backend/replication/logical/relation.c
src/backend/replication/logical/worker.c
src/test/subscription/t/013_partition.pl