> On Jun 20, 2021, at 10:11 PM, Amit Kapila <amit.kapila16@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,
therecould be many such errors for them to clear. It may be true that the second error doesn't occur on the subscriber
sideuntil after the first is cleared, but that still leaves the user having to clear one after the next until
arbitrarilymany of them coming from the publisher side are cleared.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company