Re: Understanding conflicts on publications and subscriptions

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Understanding conflicts on publications and subscriptions
Дата
Msg-id CAKFQuwYQB+yCxwEpv7zHekH8y9wmW+Oe+DN2Ly3vZwg=+F5cwA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Understanding conflicts on publications and subscriptions  (Koen De Groote <kdg.dev@gmail.com>)
Ответы Re: Understanding conflicts on publications and subscriptions
Список pgsql-general
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 по дате отправления: