pgsql: Fix data inconsistency between publisher and subscriber.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема pgsql: Fix data inconsistency between publisher and subscriber.
Дата
Msg-id E1o1gCT-000Gko-6K@gemulon.postgresql.org
обсуждение исходный текст
Список 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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/b7658c24c7c1ffad131a7fdf67ce7fc008be1177

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   | 15 +++++++++++++
4 files changed, 53 insertions(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Re-add locally-generated files in pg_upgrade's .gitignore and Ma
Следующее
От: Michael Paquier
Дата:
Сообщение: pgsql: Fix comment in regression tests for large objects