Re: Type casting bug in 8.1.[67]? - Mailing list pgsql-hackers

From Michael Paesold
Subject Re: Type casting bug in 8.1.[67]?
Date
Msg-id 45C8D14A.90502@gmx.at
Whole thread Raw
In response to Re: Type casting bug in 8.1.[67]?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Ooops ... seems we need a re-release pronto
Next
From: Jim Nasby
Date:
Subject: Re: Ooops ... seems we need a re-release pronto