Re: Logical replication without a Primary Key

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Logical replication without a Primary Key
Дата
Msg-id CA+TgmoYGBSxW9w+4hfucPe7iRhJtpCRL=VwdFcjZw5zKkDj-vQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical replication without a Primary Key  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
Ответы Re: Logical replication without a Primary Key  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
On Thu, Dec 7, 2017 at 9:43 AM, Petr Jelinek
<petr.jelinek@2ndquadrant.com> wrote:
> No it won't, it will update only one row, it does not try to find
> multiple matching rows.

Good, because that's exactly what it should do.  I mean, if you have
on the master two tuples that are identical, and you update one of
them, then the replica had better update exactly one of them as well.
Since they are identical, it doesn't matter *which* one gets updated
on the replica, but if you update *both* of them on the replica, then
things are out of sync.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pgsql: Support Parallel Append plan nodes.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Speeding up pg_upgrade