public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Koen De Groote <[email protected]>
Cc: PostgreSQL General <[email protected]>
Subject: Re: Understanding conflicts on publications and subscriptions
Date: Tue, 30 Jul 2024 07:04:01 -0700
Message-ID: <CAKFQuwY1Fs0-a_wPidhcbdC2o503bBAVjXdbLN-QozC5HMqATA@mail.gmail.com> (raw)
In-Reply-To: <CAGbX52FGYVfXStV0Z7jPokCE_CpFEDahZAS1CqLg_9qwHke4dA@mail.gmail.com>
References: <CAGbX52FFehm9PnRef5_KeAwbUqxr6-6PprVCpUhORb5nH1txQg@mail.gmail.com>
<CAGbX52FGYVfXStV0Z7jPokCE_CpFEDahZAS1CqLg_9qwHke4dA@mail.gmail.com>
On Tuesday, July 30, 2024, Koen De Groote <[email protected]> wrote:
>
> 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.
>
The wording for that option is:
Specifies whether the subscription should be automatically disabled if any
errors are detected by subscription workers during data replication from
the publisher.
A subscription worker has no clue what the publisher is doing. It operates
on the “when I see data I act on it” model.
As for whether the publisher should have this clause - the errors in
question are logical, data-oriented, errors, which the publisher is
incapable of having.
I believe what you are effectively requesting is that instead of
disallowing updates and deletes on the added table that lacks replica
identity you wish for the addition itself to fail. That would have made a
better default behavior with an option to override when the current
behavior is desired. But it seems too late to change this decision now.
David J.
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Understanding conflicts on publications and subscriptions
In-Reply-To: <CAKFQuwY1Fs0-a_wPidhcbdC2o503bBAVjXdbLN-QozC5HMqATA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox