On Fri, Jun 30, 2017 at 7:01 PM, Yugo Nagata <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
