RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL
Date
Msg-id TYAPR01MB586607EB47374B7D5C595B0CF530A@TYAPR01MB5866.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL  (Peter Smith <smithpb2250@gmail.com>)
Responses Re: doc: clarify the limitation for logical replication when REPILICA IDENTITY is FULL
List 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


Attachment

pgsql-hackers by date:

Previous
From: Alena Rybakina
Date:
Subject: Re: POC, WIP: OR-clause support for indexes
Next
From: Daniel Gustafsson
Date:
Subject: Re: RADIUS tests and improvements