Re: Understanding conflicts on publications and subscriptions - Mailing list pgsql-general

From Koen De Groote
Subject Re: Understanding conflicts on publications and subscriptions
Date
Msg-id CAGbX52FGYVfXStV0Z7jPokCE_CpFEDahZAS1CqLg_9qwHke4dA@mail.gmail.com
Whole thread Raw
In response to Understanding conflicts on publications and subscriptions  (Koen De Groote <kdg.dev@gmail.com>)
Responses Re: Understanding conflicts on publications and subscriptions
List pgsql-general
Just to add a thought:

If the subscriber gets a bit of logic to say "Something went wrong, so I'm automatically stopping what I'm doing", it sounds logical to give the publisher the same ability.

On Tue, Jul 30, 2024 at 3:47 PM Koen De Groote <kdg.dev@gmail.com> wrote:

There is talk of the "disable_on_error" option when creating a subscription.

The conflicts this applies to, I am assuming are only conflicts caused on the side of the subscription?

As an attempt to apply new data doesn't work, because of modifications made since the initial copy, is that correct?


I'm a bit confused by errors on the side of the publisher. Reading this document: https://www.postgresql.org/docs/16/sql-createpublication.html

It states:

> The tables added to a publication that publishes UPDATE and/or DELETE operations must have REPLICA IDENTITY defined. Otherwise those operations will be disallowed on those tables.

This is not related to the subscription option "disable_on_error", I take it?

Because it sure would be nice if there was a way to do a similar thing for the subscription, disabling it on error.

Am I getting this right? "disable_on_error" is only on subscription, and errors on the publishers related to replica identity are not tied to that?

Thanks for your time.

pgsql-general by date:

Previous
From: Koen De Groote
Date:
Subject: Understanding conflicts on publications and subscriptions
Next
From: "David G. Johnston"
Date:
Subject: Re: Understanding conflicts on publications and subscriptions