pgsql: Fix ALTER PUBLICATION...DROP TABLE behavior.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix ALTER PUBLICATION...DROP TABLE behavior.
Date: 2021-01-25 02:21:09
Message-ID: E1l3rV7-0000DL-8S@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix ALTER PUBLICATION...DROP TABLE behavior.

Commit 69bd60672 fixed the initialization of streamed transactions for
RelationSyncEntry. It forgot to initialize the publication actions while
invalidating the RelationSyncEntry due to which even though the relation
is dropped from a particular publication we still publish its changes. Fix
it by initializing pubactions when entry got invalidated.

Author: Japin Li and Bharath Rupireddy
Reviewed-by: Amit Kapila
Discussion: https://postgr.es/m/CALj2ACV+0UFpcZs5czYgBpujM9p0Hg1qdOZai_43OU7bqHU_xw@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/40ab64c1ec1cb9bd73695f519cf66ddbb97d8144

Modified Files
--------------
src/backend/replication/pgoutput/pgoutput.c | 11 ++++
src/test/subscription/t/001_rep_changes.pl | 95 ++++++++++++++++++++++++++++-
2 files changed, 105 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message David Rowley 2021-01-25 06:52:42 pgsql: Fix hypothetical bug in heap backward scans
Previous Message Tom Lane 2021-01-24 23:09:01 pgsql: Make storage/standby.h compile standalone again.