Horton

Set pg_class.relhassubclass for partitioned indexes

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: 17f206fbc824d2b4b14480199ca9ff7dea417eda
Author: Michael Paquier <michael@paquier.xyz>
Date: 2018-10-22T02:04:48Z
Releases: 12.0 
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

Files

PathChange+/−
src/backend/catalog/index.c modified +4 −1
src/backend/commands/indexcmds.c modified +4 −0
src/test/regress/expected/indexing.out modified +38 −18
src/test/regress/sql/indexing.sql modified +16 −2

Discussion