From: Jan Wieck <JanWieck@Yahoo.com>
To: Thomas O'Connell <tfo@monsterlabs.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: double precision to numeric overflow error
Date: Fri, 17 Jan 2003 15:43:31 -0500
Message-ID: <3E286AF3.5272F9FA@Yahoo.com> (raw)
References: <726.1041999309@sss.pgh.pa.us>
<tfo-E9C401.23361207012003@news.hub.org>
Thomas O'Connell wrote:
>
> Well, it would've immediately (rather than the several minutes it took)
> given away the problem if it read something like:
>
> ERROR: overflow caused by cast of double precision value to numeric
> without sufficient precision, scale (15, 6)
>
> or even, depending on how much detail is available or how much worth
> assigned to error reporting:
The message will be exactly the same in all cases, since there is no
more detail. I think words about casting and such could be fairly
confusing in the case someone just inserts a literal value - no?
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: JanWieck@Yahoo.com, tfo@monsterlabs.com, pgsql-general@postgresql.org
Subject: Re: double precision to numeric overflow error
In-Reply-To: <3E286AF3.5272F9FA@Yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox