pgsql: Fix a WARNING for data origin discrepancies.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix a WARNING for data origin discrepancies.
Date: 2025-02-21 09:17:33
Message-ID: E1tlPA7-000Rf0-0B@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix a WARNING for data origin discrepancies.

Previously, a WARNING was issued at the time of defining a subscription
with origin=NONE only when the publisher subscribed to the same table from
other publishers, indicating potential data origination from different
origins. However, the publisher can subscribe to the partition ancestors
or partition children of the table from other publishers, which could also
result in mixed-origin data inclusion. So, give a WARNING in those cases
as well.

Reported-by: Sergey Tatarintsev <s(dot)tatarintsev(at)postgrespro(dot)ru>
Author: Hou Zhijie <houzj(dot)fnst(at)fujitsu(dot)com>
Author: Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>
Reviewed-by: Vignesh C <vignesh21(at)gmail(dot)com>
Reviewed-by: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Backpatch-through: 16, where it was introduced
Discussion: https://postgr.es/m/5eda6a9c-63cf-404d-8a49-8dcb116a29f3@postgrespro.ru

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/ref/create_subscription.sgml | 12 +--
src/backend/commands/subscriptioncmds.c | 15 ++--
src/test/subscription/t/030_origin.pl | 120 +++++++++++++++++++++++++++++-
3 files changed, 133 insertions(+), 14 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Daniel Gustafsson 2025-02-21 10:29:46 pgsql: doc: Add links to olsen93 and ong90 in bibliography
Previous Message Michael Paquier 2025-02-21 08:31:55 pgsql: Add missing deparsing of [NO] IDENT to XMLSERIALIZE()