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 CAGbX52F6SUUyENBq=E4rHYgfOnj2KTcgCfS=g9Y=Fna+dWfi_Q@mail.gmail.com
Whole thread Raw
In response to Re: Understanding conflicts on publications and subscriptions  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
It indeed seems to be that.

My initial thought of " will be disallowed on those tables" was "on the subscriber side". After all, why have a publication be of any effect if there's nobody subscribing to it.

But it appears the publication influences behavior, regardless of there being a subscriber, which feels counter-intuitive to me.

Thanks for stepping me through it.

On Tue, Jul 30, 2024 at 4:34 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Jul 30, 2024 at 7:16 AM Koen De Groote <kdg.dev@gmail.com> wrote:
 And if my understanding is correct: if a table doesn't have a replica identity, any UPDATE or DELETE statement that happens on the publisher, for that table, will be refused.


That is how I read the sentence "Otherwise those operations will be disallowed on those tables."

Upon adding said table to a publication, future attempts to run updates and deletes will result in failures in the transactions performing said DML.

Feel free to experiment that the behavior indeed matches the wording in the documentation.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Trigger usecase
Next
From: Alban Hertroys
Date:
Subject: Re: Trigger usecase