pgsql: Disallow CREATE/DROP SUBSCRIPTION in transaction block

Started by Peter Eisentrautover 9 years ago1 messagescomitters

peter_e@gmx.net

over 9 years ago

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.mshk@gmail.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(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers