Improve wording of error message added in commit 7148050.

tglsfdc · tglsfdc · commit 6c77b47b2e8e · 2017-09-26T15:25:57.000-04:00
Per suggestions from Peter Eisentraut and David Johnston. Back-patch, like the previous commit. Discussion: https://postgr.es/m/E1dv9jI-0006oT-Fn@gemulon.postgresql.org
diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c
@@ -395,7 +395,7 @@ do_analyze_rel(Relation onerel, VacuumStmt *vacstmt,
 			if (bms_is_member(i, unique_cols))
 				ereport(ERROR,
 						(errcode(ERRCODE_DUPLICATE_COLUMN),
-						 errmsg("column \"%s\" of relation \"%s\" is specified twice",
+						 errmsg("column \"%s\" of relation \"%s\" appears more than once",
 								col, RelationGetRelationName(onerel))));
 			unique_cols = bms_add_member(unique_cols, i);
 
diff --git a/src/test/regress/expected/vacuum.out b/src/test/regress/expected/vacuum.out
@@ -81,8 +81,8 @@ SQL function "wrap_do_analyze" statement 1
 VACUUM FULL vactst;
 -- check behavior with duplicate column mentions
 VACUUM ANALYZE vaccluster(i,i);
-ERROR:  column "i" of relation "vaccluster" is specified twice
+ERROR:  column "i" of relation "vaccluster" appears more than once
 ANALYZE vaccluster(i,i);
-ERROR:  column "i" of relation "vaccluster" is specified twice
+ERROR:  column "i" of relation "vaccluster" appears more than once
 DROP TABLE vaccluster;
 DROP TABLE vactst;
