RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL

Поиск
Список
Период
Сортировка
От Hayato Kuroda (Fujitsu)
Тема RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL
Дата
Msg-id TYAPR01MB586607EB47374B7D5C595B0CF530A@TYAPR01MB5866.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL  (Peter Smith <smithpb2250@gmail.com>)
Ответы Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Dear Peter,

Thanks for checking! PSA new version.

> 1.
> SUGGESTION (minor reword)
> If the published table specifies <literal>REPLICA IDENTITY
> FULL</literal> but the table includes an attribute whose datatype is
> not an operator class of Btree, then <literal>UPDATE</literal> and
> <literal>DELETE</literal> operations cannot be replicated. To make it
> work, a primary key should be defined on the subscriber table, or a
> different appropriate replica identity must be specified.

Seems better, fixed.

> 2.
> Maybe "REPLICA IDENTITY FULL" should have a link, like from this [1] page.

Added.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED


Вложения

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

Предыдущее
От: Alena Rybakina
Дата:
Сообщение: Re: POC, WIP: OR-clause support for indexes
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: RADIUS tests and improvements