Re: Logical replication without a Primary Key

Поиск
Список
Период
Сортировка
От Chapman Flack
Тема Re: Logical replication without a Primary Key
Дата
Msg-id 5b854760-6243-9d75-4614-88ee34e15854@anastigmatix.net
обсуждение исходный текст
Ответ на Re: Logical replication without a Primary Key  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Logical replication without a Primary Key  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 12/07/2017 02:38 PM, Joshua D. Drake wrote:

> A    B   C
> foo,bar,baz
> foo,bar,baz
> 
> And then I say:
> 
> UPDATE test set A = 1 where C = baz
> 
> I have updated two rows because there is no primary key to identify the
> differences. Both of those rows should be updated and thus replicated

Would the subscriber see two records reporting update of a
foo,bar,baz row to 1, so it would do that to (arbitrarily)
one of them the first time, and (necessarily) the other, the
second time?

Or is that not the way it would work?

-Chap


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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: [HACKERS] CUBE seems a bit confused about ORDER BY
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Signals in a BGW