[COMMITTERS] pgsql: Fix updating of pg_subscription_rel from workers - Mailing list pgsql-committers

From Peter Eisentraut
Subject [COMMITTERS] pgsql: Fix updating of pg_subscription_rel from workers
Date
Msg-id E1dIfAQ-0007kv-EA@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix updating of pg_subscription_rel from workers

A logical replication worker should not insert new rows into
pg_subscription_rel, only update existing rows, so that there are no
races if a concurrent refresh removes rows.  Adjust the API to be able
to choose that behavior.

Author: Masahiko Sawada <sawada.mshk@gmail.com>
Reported-by: tushar <tushar.ahuja@enterprisedb.com>

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/644ea35fc1352d845299563c7ddfb8b524ed27d9

Modified Files
--------------
src/backend/catalog/pg_subscription.c       | 13 +++++++++----
src/backend/commands/subscriptioncmds.c     |  4 ++--
src/backend/replication/logical/tablesync.c | 11 +++++++----
src/include/catalog/pg_subscription_rel.h   |  2 +-
4 files changed, 19 insertions(+), 11 deletions(-)


pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: [COMMITTERS] pgsql: Prevent BEFORE triggers from violating partitioningconstraints.
Next
From: Robert Haas
Date:
Subject: [COMMITTERS] pgsql: postgres_fdw: Allow cancellation of transaction controlcommands