Re: [HACKERS] Fix doc of DROP SUBSCRIPTION

On Fri, 30 Jun 2017 20:17:39 +0900
Masahiko Sawada <sawada.mshk@gmail.com> wrote:

> On Fri, Jun 30, 2017 at 7:01 PM, Yugo Nagata <nagata@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 <nagata@sraoss.co.jp>