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

  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:

Reply via email to