Support case of adding predicate in ALTER INDEX ... WHERE ...

knizhnik · kelvich · commit 2dac382a09cd · 2016-02-03T19:21:36.000+03:00
diff --git a/src/backend/commands/indexcmds.c b/src/backend/commands/indexcmds.c
@@ -361,7 +361,9 @@ AlterIndex(Oid indexRelationId, IndexStmt *stmt)
 	relationName = quote_qualified_identifier(get_namespace_name(namespaceId),
 											  get_rel_name(heapRelationId)),
 	newIndexPredicate = deparse_expression(stmt->whereClause, deparseCtx, false, false);
-	oldIndexPredicate = deparse_expression((Node*)make_ands_explicit(indexInfo->ii_Predicate), deparseCtx, false, false);
+	oldIndexPredicate = indexInfo->ii_Predicate 
+		? deparse_expression((Node*)make_ands_explicit(indexInfo->ii_Predicate), deparseCtx, false, false)
+		: "true";
 
     SPI_connect();
 
