Re: Optionally automatically disable logical replication subscriptions on error

[Mark Dilger]

> On Jun 20, 2021, at 10:11 PM, Amit Kapila <amit.kapil...@gmail.com> wrote:
> 
> Then also it will fail on the first such conflict, so even without
> your patch, the apply worker corresponding to the subscription won't
> be able to proceed after the first error, it won't lead to multiple
> failing xids. 

I'm not sure we're talking about the same thing.  I'm saying that if the user 
is expected to clear each error manually, there could be many such errors for 
them to clear.  It may be true that the second error doesn't occur on the 
subscriber side until after the first is cleared, but that still leaves the 
user having to clear one after the next until arbitrarily many of them coming 
from the publisher side are cleared.

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company