On 30/06/17 15:17, Yugo Nagata wrote: > 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. >
It will only fail if the remote site is not reachable during the drop (but then it should hint about the ALTER), maybe that's what happened to you? -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
