On Fri, Jun 30, 2017 at 7:01 PM, Yugo Nagata <nag...@sraoss.co.jp> wrote: > Hi, > > The documentation says that a subscription that has a replication slot > cannot be dropped in a transaction block, but it is not allowed even > outside of a transaction block.
Hmm, I think we can drop a subscription outside of a transaction block even if the subscription associates with a replication. =# table pg_subscription; subdbid | subname | subowner | subenabled | subconninfo | subslotname | subsynccommit | subpublications ---------+----------+----------+------------+---------------------------+-------------+---------------+----------------- 13164 | hoge_sub | 10 | t | dbname=postgres port=5550 | hoge_sub | off | {one_pub} (1 row) =# drop subscription hoge_sub ; DROP SUBSCRIPTION Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers