Fix data inconsistency between publisher and subscriber.
authorAmit Kapila <akapila@postgresql.org>
Thu, 16 Jun 2022 02:54:22 +0000 (08:24 +0530)
committerAmit Kapila <akapila@postgresql.org>
Thu, 16 Jun 2022 02:54:22 +0000 (08:24 +0530)
commit1f9a7738eb84f341a9b39689f33c887d1ef39487
tree7096227cd9132ef6f223c091c0192d78f62b2b08
parent16f5a8da76f21576987790df828082cb7bb1bdad
Fix data inconsistency between publisher and subscriber.

We were not updating the partition map cache in the subscriber even when
the corresponding remote rel is changed. Due to this data was getting
incorrectly replicated for partition tables after the publisher has
changed the table schema.

Fix it by resetting the required entries in the partition map cache after
receiving a new relation mapping from the publisher.

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/include/replication/logicalrelation.h
src/test/subscription/t/013_partition.pl