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

From: Michael Paesold <mpaesold(at)gmx(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Type casting bug in 8.1.[67]?
Date: 2007-02-06 19:04:42
Message-ID: 45C8D14A.90502@gmx.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Michael Paesold <mpaesold(at)gmx(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2007-02-06 19:05:25 Re: Ooops ... seems we need a re-release pronto
Previous Message Tom Lane 2007-02-06 18:40:41 Re: Ooops ... seems we need a re-release pronto