pgsql: Fix interference between covering indexes and partitioned tables

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix interference between covering indexes and partitioned tables
Date: 2018-04-12 14:25:49
Message-ID: E1f6dAb-00073O-47@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix interference between covering indexes and partitioned tables

The bug is caused due to the original IndexStmt that DefineIndex receives
being overwritten when processing the INCLUDE columns. Use separate list of
index params to propagate to child tables. Add tests covering this case.

Amit Langote and Alexander Korotkov.

Re-commit 5c6110c6a960ad6fe1b0d0fec6ae36ef4eb913f5 because it discovered a bug
fixed in c266ed31a8a3beed3533e6a78faeca78234cbd43

Discussion: https://www.postgresql.org/message-id/CAJGNTeO%3DBguEyG8wxMpU_Vgvg3nGGzy71zUQ0RpzEn_mb0bSWA%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/524054598fd300c75007f53aebd67f9ced33b7db

Modified Files
--------------
src/backend/commands/indexcmds.c | 27 ++++++++++++++-------------
src/test/regress/expected/indexing.out | 24 ++++++++++++++++++++++++
src/test/regress/sql/indexing.sql | 19 +++++++++++++++++++
3 files changed, 57 insertions(+), 13 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-04-12 14:39:07 pgsql: Fix YA parallel-make hazard, this one in "make check" in plpytho
Previous Message Teodor Sigaev 2018-04-12 13:38:11 pgsql: Cleanup covering infrastructure