Error message improvement

petere · petere · commit c2ff42c6c163 · 2018-02-20T17:58:27.000-05:00
diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c
@@ -1369,7 +1369,7 @@ ExecuteTruncate(TruncateStmt *stmt)
 			ereport(ERROR,
 					(errcode(ERRCODE_WRONG_OBJECT_TYPE),
 					 errmsg("cannot truncate only a partitioned table"),
-					 errhint("Do not specify the ONLY keyword, or use truncate only on the partitions directly.")));
+					 errhint("Do not specify the ONLY keyword, or use TRUNCATE ONLY on the partitions directly.")));
 	}
 
 	/*
diff --git a/src/test/regress/expected/truncate.out b/src/test/regress/expected/truncate.out
@@ -455,12 +455,12 @@ CREATE TABLE truncparted (a int, b char) PARTITION BY LIST (a);
 -- error, can't truncate a partitioned table
 TRUNCATE ONLY truncparted;
 ERROR:  cannot truncate only a partitioned table
-HINT:  Do not specify the ONLY keyword, or use truncate only on the partitions directly.
+HINT:  Do not specify the ONLY keyword, or use TRUNCATE ONLY on the partitions directly.
 CREATE TABLE truncparted1 PARTITION OF truncparted FOR VALUES IN (1);
 INSERT INTO truncparted VALUES (1, 'a');
 -- error, must truncate partitions
 TRUNCATE ONLY truncparted;
 ERROR:  cannot truncate only a partitioned table
-HINT:  Do not specify the ONLY keyword, or use truncate only on the partitions directly.
+HINT:  Do not specify the ONLY keyword, or use TRUNCATE ONLY on the partitions directly.
 TRUNCATE truncparted;
 DROP TABLE truncparted;

Original file line number	Diff line number	Diff line change
`@@ -1369,7 +1369,7 @@ ExecuteTruncate(TruncateStmt *stmt)`
`1369`	`1369`	`ereport(ERROR,`
`1370`	`1370`	`(errcode(ERRCODE_WRONG_OBJECT_TYPE),`
`1371`	`1371`	`errmsg("cannot truncate only a partitioned table"),`
`1372`		`- errhint("Do not specify the ONLY keyword, or use truncate only on the partitions directly.")));`
	`1372`	`+ errhint("Do not specify the ONLY keyword, or use TRUNCATE ONLY on the partitions directly.")));`
`1373`	`1373`	`}`
`1374`	`1374`
`1375`	`1375`	`/*`