diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-09-26 15:25:56 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-09-26 15:25:56 -0400 |
| commit | f4aac742c8293b1a0535a8133f926d46474300f0 (patch) | |
| tree | fe6bf1df2d1fcddd216d4f0a48eb6bb647300c85 /src | |
| parent | 12ac252f9014a96c0b7159912659fa4d0f9cbc07 (diff) | |
| download | postgresql-f4aac742c8293b1a0535a8133f926d46474300f0.tar.gz postgresql-f4aac742c8293b1a0535a8133f926d46474300f0.zip | |
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
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/commands/analyze.c | 2 | ||||
| -rw-r--r-- | 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 c58f3096e63..79fcb54e3a0 100644 --- a/src/backend/commands/analyze.c +++ b/src/backend/commands/analyze.c @@ -382,7 +382,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 23a877e9cca..540f4f3014a 100644 --- a/src/test/regress/expected/vacuum.out +++ b/src/test/regress/expected/vacuum.out @@ -82,8 +82,8 @@ VACUUM FULL vactst; VACUUM (DISABLE_PAGE_SKIPPING) vaccluster; -- 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; |