diff options
| author | Michael Paquier <michael@paquier.xyz> | 2018-12-18 16:37:51 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2018-12-18 16:37:51 +0900 |
| commit | f94cec64476f2752e91b10d7928a2fcd105e9fc3 (patch) | |
| tree | c0f43a5064112d7b93e6635cfe2e1afe04d6f0ea /src/backend | |
| parent | 3e514c1238312c56b73d956d844c67a034dead02 (diff) | |
| download | postgresql-f94cec64476f2752e91b10d7928a2fcd105e9fc3.tar.gz postgresql-f94cec64476f2752e91b10d7928a2fcd105e9fc3.zip | |
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
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 8630542bb34..5253837b544 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -162,7 +162,7 @@ CREATE VIEW pg_indexes AS JOIN pg_class I ON (I.oid = X.indexrelid) LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) LEFT JOIN pg_tablespace T ON (T.oid = I.reltablespace) - WHERE C.relkind IN ('r', 'm') AND I.relkind = 'i'; + WHERE C.relkind IN ('r', 'm', 'p') AND I.relkind IN ('i', 'I'); CREATE OR REPLACE VIEW pg_sequences AS SELECT |