pgsql: Disallow CREATE/DROP SUBSCRIPTION in transaction block

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Disallow CREATE/DROP SUBSCRIPTION in transaction block
Date: 2017-03-04 04:43:34
Message-ID: E1ck1Xa-0007tM-3i@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Disallow CREATE/DROP SUBSCRIPTION in transaction block

Disallow CREATE SUBSCRIPTION and DROP SUBSCRIPTION in a transaction
block when the replication slot is to be created or dropped, since that
cannot be rolled back.

based on patch by Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/272adf4f9cd67df323ae57ff3dee238b649d3b73

Modified Files
--------------
doc/src/sgml/ref/create_subscription.sgml | 5 ++++
doc/src/sgml/ref/drop_subscription.sgml | 4 ++--
src/backend/commands/subscriptioncmds.c | 38 +++++++++++++++++++++++-------
src/backend/tcop/utility.c | 5 ++--
src/include/commands/subscriptioncmds.h | 5 ++--
src/test/regress/expected/subscription.out | 12 ++++++++++
src/test/regress/sql/subscription.sql | 12 ++++++++++
7 files changed, 66 insertions(+), 15 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Petr Jelinek 2017-03-04 06:45:58 Re: [COMMITTERS] pgsql: Use asynchronous connect API in libpqwalreceiver
Previous Message Tom Lane 2017-03-04 04:11:33 Re: [COMMITTERS] pgsql: Use asynchronous connect API in libpqwalreceiver