Horton

Include partitioned indexes to system view pg_indexes

Michael Paquier <michael@paquier.xyz>

View on postgr.es
Commit: f94cec64476f2752e91b10d7928a2fcd105e9fc3
Author: Michael Paquier <michael@paquier.xyz>
Date: 2018-12-18T07:37:51Z
Releases: 12.0 
Include partitioned indexes to system view pg_indexes

pg_tables already includes partitioned tables, so for consistency
pg_indexes should show partitioned indexes.

Author: Suraj Kharage
Reviewed-by: Amit Langote, Michael Paquier
Discussion: https://postgr.es/m/CAF1DzPVrYo4XNTEnc=PqVp6aLJc7LFYpYR4rX=_5pV=wJ2KdZg@mail.gmail.com

Files

PathChange+/−
src/backend/catalog/system_views.sql modified +1 −1
src/include/catalog/catversion.h modified +1 −1
src/test/regress/expected/indexing.out modified +7 −0
src/test/regress/expected/rules.out modified +1 −1
src/test/regress/sql/indexing.sql modified +3 −0

Discussion