Horton

Re: Type casting bug in 8.1.[67]?

Michael Paesold <mpaesold@gmx.at>

View thread View on postgr.es
From: Michael Paesold <mpaesold@gmx.at>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2007-02-06T19:04:42Z
Lists: pgsql-hackers 
Tom Lane wrote:
> Michael Paesold <mpaesold@gmx.at> writes:
>> after upgrading from 8.1.5 to 8.1.7, I got errors in the server log when 
>> updating decimal values using string constants.
> 
> Have you got a constraint or functional index on that column?

Yes.

Check constraints:
     "tc_reminder_charges" CHECK (reminder_charges >= 0::numeric)

As I read from your other post, you already figured that the issue is 
related to check constraints (or functional indexes).

Best Regards,
Michael Paesold