On Fri, 30 Jun 2017 20:17:39 +0900 Masahiko Sawada <sawada.m...@gmail.com> wrote:
> 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. Sorry, I was wrong and missing something... I confirmaed it. The documentation is right. Sorry for the noise. > > =# 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 -- Yugo Nagata <nag...@sraoss.co.jp> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers