From c2ff42c6c1631c6c67d09fc8574186a984566a0d Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 20 Feb 2018 17:58:27 -0500 Subject: [PATCH] Error message improvement --- src/backend/commands/tablecmds.c | 2 +- src/test/regress/expected/truncate.out | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c index db6c8ff00e..74e020bffc 100644 --- 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 index d967e8dd21..735d0e862d 100644 --- 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; -- 2.40.0