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

2007-02-06 Thread Martijn van Oosterhout 
On Tue, Feb 06, 2007 at 12:34:50PM +0100, Michael Paesold wrote:
 Hello all,
 
 after upgrading from 8.1.5 to 8.1.7, I got errors in the server log when 
 updating decimal values using string constants. I tried the same using 
 psql (pasted the query from below) and it fails, too. Downgrading to 
 8.1.5 resolved the issue.

Someone on -general just posted exactly the same problem for 8.1.7. I
wonder if the recent security update broke something else?

Have a nice day,
-- 
Martijn van Oosterhout   kleptog@svana.org   http://svana.org/kleptog/
 From each according to his ability. To each according to his ability to 
 litigate.


signature.asc
Description: Digital signature

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

2007-02-06 Thread Tom Lane 
Michael Paesold [EMAIL PROTECTED] 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?

regards, tom lane

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

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

2007-02-06 Thread Michael Paesold 

Tom Lane wrote:

Michael Paesold [EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

   http://www.postgresql.org/about/donate