On 2017-06-07 23:18, Alvaro Herrera wrote:
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.

You're right, that makes sense.
Thanks.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to