postgres.git / summary / log / commit / refs

commit    bd797eaa9a056d95e9a1b657755d3abc2d93a6c8
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Sep 26 19:25:56 2017 +0000

    Improve wording of error message added in commit 714805010.
    
    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


 src/backend/commands/analyze.c       | 2 +-
 src/test/regress/expected/vacuum.out | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/backend/commands/analyze.c b/src/backend/commands/analyze.c
index f3d395f675b..268905aca94 100644
--- a/src/backend/commands/analyze.c
+++ b/src/backend/commands/analyze.c
@@ -384,7 +384,7 @@ do_analyze_rel(Relation onerel, int options, VacuumParams *params,
 			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
index bf5034ad685..fda1b390c09 100644
--- 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;


[parent: 06852f21544c]