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.