Re: [HACKERS] logical replication - possible remaining problem

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.