pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Doc: clarify the conditions of usable indexes for REPLICA IDENTI 2+ messages / 1 participants [nested] [flat]
* pgsql: Doc: clarify the conditions of usable indexes for REPLICA IDENTI @ 2023-07-13 06:05 Masahiko Sawada <msawada@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Masahiko Sawada @ 2023-07-13 06:05 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/fd48a86c6241b994ce67c8b53a918e6b42c8063c Modified Files -------------- doc/src/sgml/logical-replication.sgml | 12 ++++++------ src/backend/executor/execReplication.c | 6 +++--- src/backend/replication/logical/relation.c | 11 ++++------- 3 files changed, 13 insertions(+), 16 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Doc: clarify the conditions of usable indexes for REPLICA IDENTI @ 2023-07-13 06:05 Masahiko Sawada <msawada@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Masahiko Sawada @ 2023-07-13 06:05 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/4946910a875ce84823236f2a06e576b16080465f Modified Files -------------- doc/src/sgml/logical-replication.sgml | 12 ++++++------ src/backend/executor/execReplication.c | 6 +++--- src/backend/replication/logical/relation.c | 11 ++++------- 3 files changed, 13 insertions(+), 16 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-07-13 06:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-07-13 06:05 pgsql: Doc: clarify the conditions of usable indexes for REPLICA IDENTI Masahiko Sawada <msawada@postgresql.org> 2023-07-13 06:05 pgsql: Doc: clarify the conditions of usable indexes for REPLICA IDENTI Masahiko Sawada <msawada@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox