Adjust_error_message_for_CREATE_STATISTICS.patch

text/x-diff

Filename: Adjust_error_message_for_CREATE_STATISTICS.patch

Type: text/x-diff

Part: 0

Message: Adjust error message for CREATE STATISTICS to account for expressions

Patch

Format: unified

File	+	−
src/backend/commands/statscmds.c	1	1

diff --git a/src/backend/commands/statscmds.c b/src/backend/commands/statscmds.c
index c1da79f36ba..b4a4e663f35 100644
--- a/src/backend/commands/statscmds.c
+++ b/src/backend/commands/statscmds.c
@@ -437,7 +437,7 @@ CreateStatistics(CreateStatsStmt *stmt, bool check_rights)
 	if ((numcols < 2) && (list_length(stxexprs) != 1))
 		ereport(ERROR,
 				(errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
-				 errmsg("extended statistics require at least 2 columns")));
+				 errmsg("extended statistics require at least 2 columns or an expression")));
 
 	/*
 	 * Sort the attnums, which makes detecting duplicates somewhat easier, and