diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-01-25 17:54:14 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-01-25 17:54:14 +0000 |
| commit | cdc15b24be5b4fa931c56f804492fe0c4ef1e76f (patch) | |
| tree | 6491acc27ecca8970b6625d15ab47190952e4d18 /src/backend/utils/adt/numeric.c | |
| parent | 7a9d197fdabdddf2a3e8f2548e247247c2b7f702 (diff) | |
| download | postgresql-cdc15b24be5b4fa931c56f804492fe0c4ef1e76f.tar.gz postgresql-cdc15b24be5b4fa931c56f804492fe0c4ef1e76f.zip | |
Improve error message when NUMERIC precision is exceeded.
Diffstat (limited to 'src/backend/utils/adt/numeric.c')
| -rw-r--r-- | src/backend/utils/adt/numeric.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/utils/adt/numeric.c b/src/backend/utils/adt/numeric.c index fb2e16ee53f..dcc9a7d6836 100644 --- a/src/backend/utils/adt/numeric.c +++ b/src/backend/utils/adt/numeric.c @@ -14,7 +14,7 @@ * Copyright (c) 1998-2005, PostgreSQL Global Development Group * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.88 2005/11/22 18:17:23 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/numeric.c,v 1.89 2006/01/25 17:54:14 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -3206,8 +3206,8 @@ apply_typmod(NumericVar *var, int32 typmod) ereport(ERROR, (errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE), errmsg("numeric field overflow"), - errdetail("The absolute value is greater than or equal to 10^%d for field with precision %d, scale %d.", - ddigits - 1, precision, scale))); + errdetail("A field with precision %d, scale %d must have an absolute value less than 10^%d.", + precision, scale, maxdigits))); break; } ddigits -= DEC_DIGITS; |