Fix replica identity check for a partitioned table.
Amit Kapila <akapila@postgresql.org>
Fix replica identity check for a partitioned table. The current publisher code checks if UPDATE or DELETE can be executed with the replica identity of the table even if it's a partitioned table. We can skip checking the replica identity for partitioned tables because the operations are actually performed on the leaf partitions (not the partitioned table). Reported-by: Brad Nicholson Author: Hou Zhijie Reviewed-by: Peter Smith, Amit Kapila Backpatch-through: 13 Discussion: https://postgr.es/m/CAMMnM%3D8i5DohH%3DYKzV0_wYuYSYvuOJoL9F5nzXTc%2ByzsG1f6rg%40mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/execReplication.c | modified | +7 −0 |
| src/test/regress/expected/publication.out | modified | +2 −0 |
| src/test/regress/sql/publication.sql | modified | +2 −0 |
Discussion
- No-op updates with partitioning and logical replication started failing in version 13 13 messages · 2022-08-03 → 2022-08-17