Subject: [PATCH] CREATE STATISTICS: Fix error message

From: Álvaro Herrera <[email-masked]>
Date: Thu, 28 Aug 2025 19:53:44 +0200

---
 src/backend/tcop/utility.c | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/src/backend/tcop/utility.c b/src/backend/tcop/utility.c
index 25fe3d58016..7f5076d2c1a 100644
--- a/src/backend/tcop/utility.c
+++ b/src/backend/tcop/utility.c
@@ -1883,7 +1883,8 @@ ProcessUtilitySlow(ParseState *pstate,
 					if (!IsA(rel, RangeVar))
 						ereport(ERROR,
 								(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
-								 errmsg("only a single relation is allowed in CREATE STATISTICS")));
+								 errmsg("cannot create statistics on specified relation"),
+								 errdetail("CREATE STATISTICS only supports tables, materialized views, foreign tables, and partitioned tables.")));
 
 					/*
 					 * CREATE STATISTICS will influence future execution plans
-- 
2.39.5

--pbl4mx6qlbtkw6pf--