pgsql: Set pg_class.relhassubclass for partitioned indexes - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Set pg_class.relhassubclass for partitioned indexes
Date
Msg-id E1gEPd3-0007fj-6U@gemulon.postgresql.org
Whole thread Raw
Responses Re: pgsql: Set pg_class.relhassubclass for partitioned indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Set pg_class.relhassubclass for partitioned indexes

Like for relations, switching this parameter is optimistic by turning it
on each time a partitioned index gains a partition.  So seeing this
parameter set to true means that the partitioned index has or has had
partitions.  The flag cannot be reset yet for partitioned indexes, which
is something not obvious anyway as partitioned relations exist to have
partitions.

This allows to track more conveniently partition trees for indexes,
which will come in use with an upcoming patch helping in listing
partition trees with an SQL-callable function.

Author: Amit Langote
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/80306490-b5fc-ea34-4427-f29c52156052@lab.ntt.co.jp

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/17f206fbc824d2b4b14480199ca9ff7dea417eda

Modified Files
--------------
src/backend/catalog/index.c            |  5 ++-
src/backend/commands/indexcmds.c       |  4 +++
src/test/regress/expected/indexing.out | 56 +++++++++++++++++++++++-----------
src/test/regress/sql/indexing.sql      | 18 +++++++++--
4 files changed, 62 insertions(+), 21 deletions(-)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: pgsql: Fix some grammar errors in bloom.sgml
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Set pg_class.relhassubclass for partitioned indexes