Erik Rijkers wrote:
> Now, looking at the script again I am thinking that it would be reasonable
> to expect that after issuing
> delete from pg_subscription;
>
> the other 2 tables are /also/ cleaned, automatically, as a consequence. (Is
> this reasonable? this is really the main question of this email).
I don't think it's reasonable to expect that the system recovers
automatically from what amounts to catalog corruption. You should be
using the DDL that removes subscriptions instead.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services