Horton

Doc: clarify the conditions of usable indexes for REPLICA IDENTITY FULL tables.

Masahiko Sawada <msawada@postgresql.org>

View on postgr.es
Commit: 4946910a875ce84823236f2a06e576b16080465f
Author: Masahiko Sawada <msawada@postgresql.org>
Date: 2023-07-13T06:03:24Z
Releases: 16.0 
Doc: clarify the conditions of usable indexes for REPLICA IDENTITY FULL tables.

Commit 89e46da5e allowed REPLICA IDENTITY FULL tables to use an index
on the subscriber during apply of update/delete. This commit clarifies
in the documentation that the leftmost field of candidate indexes must
be a column (not an expression) that references the published relation
column.

The source code comments are also updated accordingly.

Reviewed-by: Peter Smith, Amit Kapila
Discussion: https://postgr.es/m/CAD21AoDJjffEvUFKXT27Q5U8-UU9JHv4rrJ9Ke8Zkc5UPWHLvA@mail.gmail.com
Backpatch-through: 16

Files

PathChange+/−
doc/src/sgml/logical-replication.sgml modified +6 −6
src/backend/executor/execReplication.c modified +3 −3
src/backend/replication/logical/relation.c modified +4 −7

Documentation touched

Discussion