pgsql: Fix data inconsistency between publisher and subscriber. - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: Fix data inconsistency between publisher and subscriber.
Date
Msg-id E1o1gCT-000Gks-77@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/0980adfd4d021e3329bf41452ce1a1210321974f

Modified Files
--------------
src/backend/replication/logical/relation.c | 34 ++++++++++++++++++++++++++++++
src/backend/replication/logical/worker.c   |  3 +++
src/include/replication/logicalrelation.h  |  1 +
src/test/subscription/t/013_partition.pl   | 17 ++++++++++++++-
4 files changed, 54 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Re-add locally-generated files in pg_upgrade's .gitignore and Ma
Next
From: Michael Paquier
Date:
Subject: pgsql: Fix comment in regression tests for large objects