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. Attached is a patch to fix it.
Regards, -- Yugo Nagata <nag...@sraoss.co.jp>
diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml index f535c00..bb48578 100644 --- a/doc/src/sgml/ref/drop_subscription.sgml +++ b/doc/src/sgml/ref/drop_subscription.sgml @@ -38,10 +38,9 @@ DROP SUBSCRIPTION [ IF EXISTS ] <replaceable class="parameter">name</replaceable </para> <para> - <command>DROP SUBSCRIPTION</command> cannot be executed inside a - transaction block if the subscription is associated with a replication - slot. (You can use <command>ALTER SUBSCRIPTION</command> to unset the - slot.) + <command>DROP SUBSCRIPTION</command> cannot be executed if the subscription + is associated with a replication slot. (You can use <command>ALTER + SUBSCRIPTION</command> to unset the slot.) </para> </refsect1>
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
