pgsql: Improve subscription locking

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve subscription locking
Date: 2017-07-04 02:48:40
Message-ID: E1dSDtI-0004M4-5y@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve subscription locking

This avoids "tuple concurrently updated" errors when a ALTER or DROP
SUBSCRIPTION writes to pg_subscription_rel at the same time as a worker.

Author: Petr Jelinek <petr(dot)jelinek(at)2ndquadrant(dot)com>

Branch
------
master

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

Modified Files
--------------
src/backend/catalog/pg_subscription.c | 4 ++++
src/backend/commands/subscriptioncmds.c | 3 +++
2 files changed, 7 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2017-07-04 03:39:05 pgsql: Document how logical replication deals with statement triggers
Previous Message Magnus Hagander 2017-07-03 15:17:15 pgsql: Don't mention SSL methods that aren't reachable in docs