From d7905aa1da00115d56ca199b848bcc93fbedf2c8 Mon Sep 17 00:00:00 2001 From: Álvaro Herrera Date: Tue, 7 Jan 2025 20:07:32 +0100 Subject: Fix error message wording The originals are ambiguous and a bit out of style. Reviewed-by: Amit Langote Discussion: https://postgr.es/m/202412141243.efesjyyvzxsz@alvherre.pgsql --- src/backend/parser/parse_expr.c | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src/backend/parser') diff --git a/src/backend/parser/parse_expr.c b/src/backend/parser/parse_expr.c index ef0b560f5e3..3905dd36340 100644 --- a/src/backend/parser/parse_expr.c +++ b/src/backend/parser/parse_expr.c @@ -4115,8 +4115,9 @@ transformJsonReturning(ParseState *pstate, JsonOutput *output, const char *fname if (returning->typid != JSONOID && returning->typid != JSONBOID) ereport(ERROR, (errcode(ERRCODE_DATATYPE_MISMATCH), - errmsg("cannot use RETURNING type %s in %s", + errmsg("cannot use type %s in RETURNING clause of %s", format_type_be(returning->typid), fname), + errhint("Try returning json or jsonb."), parser_errposition(pstate, output->typeName->location))); } else @@ -4235,7 +4236,7 @@ transformJsonSerializeExpr(ParseState *pstate, JsonSerializeExpr *expr) if (typcategory != TYPCATEGORY_STRING) ereport(ERROR, (errcode(ERRCODE_DATATYPE_MISMATCH), - errmsg("cannot use RETURNING type %s in %s", + errmsg("cannot use type %s in RETURNING clause of %s", format_type_be(returning->typid), "JSON_SERIALIZE()"), errhint("Try returning a string type or bytea."))); -- cgit v1.2.3