]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: clarify the conditions of usable indexes for REPLICA IDENTITY FULL tables.
authorMasahiko Sawada <msawada@postgresql.org>
Thu, 13 Jul 2023 06:03:24 +0000 (15:03 +0900)
committerMasahiko Sawada <msawada@postgresql.org>
Thu, 13 Jul 2023 06:03:24 +0000 (15:03 +0900)
commit4946910a875ce84823236f2a06e576b16080465f
tree27ec064175f9fff722119176262658ef8a8e44cb
parent7fc064d9b70f58998d3e8de78ece52b4e1376428
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
doc/src/sgml/logical-replication.sgml
src/backend/executor/execReplication.c
src/backend/replication/logical/relation.c