Re: DROP SUBSCRIPTION with no slot

This also seems to be a problem for somewhat fringe case of subscriptions created with connect=false option.

They cannot be dropped in an obvious way, without knowing the ALTER SUBSCRIPTION trick.

For example:

contrib_regression=# create subscription test_sub connection 'dbname=contrib_regression' publication test_pub with ( connect=false );                                                                                                                 

WARNING:  tables were not subscribed, you will have to run ALTER SUBSCRIPTION ... REFRESH PUBLICATION to subscribe the tables

CREATE SUBSCRIPTION

contrib_regression=# drop subscription test_sub; -- fails

ERROR:  could not drop the replication slot "test_sub" on publisher

DETAIL:  The error was: ERROR:  replication slot "test_sub" does not exist

contrib_regression=# alter subscription test_sub set ( slot_name=none );

ALTER SUBSCRIPTION

contrib_regression=# drop subscription test_sub; -- succeeds

DROP SUBSCRIPTION

Note that the publication was never refreshed.

It seems that the first DROP should succeed in the above case. 

Or at least some hint should be given how to fix this.