diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 4fc5d5a..28707ee 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -151,7 +151,7 @@ CREATE VIEW pg_indexes AS C.relname AS tablename, I.relname AS indexname, T.spcname AS tablespace, - pg_get_indexdef(I.oid) AS indexdef + pg_get_indexdef(X.indexrelid) AS indexdef FROM pg_index X JOIN pg_class C ON (C.oid = X.indrelid) JOIN pg_class I ON (I.oid = X.indexrelid) LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)