Re: Error Message: ERROR: Bad numeric input format '-591,87'

Hi,

This error normally occurs because the backend database doesn't like the
style of number you are using. Try entering '-591.87' instead.

Regards Dave.

_____

From: Robson Richieri [mailto:rob-richieri(at)bol(dot)com(dot)br]
Sent: 18 February 2004 14:46
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Error Message: ERROR: Bad numeric
input format '-591,87'



-- System Information --

Platform: Windows 2000
Version: 5.0
Build: 2195 Service Pack 2

-- Application Information --

Name: pgAdmin II
Version: 1.6.0
Descripton:

Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0

-- Database Information --

Version: 7.2.1
Descripton: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by
GCC 2.95.3

-- Driver Information --

Name: PostgreSQL
Version: 7.3.100
Descripton: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by
GCC 2.95.3

-- Error Information --

Description: ERROR: Bad numeric input format '-591,87'
Number: -2147467259
Routine: pgAdmin II:frmSQLOutput.cmdSave_Click

************************************************************

Insert your comment:

Trying to update (edit) a record in a field defined as
numeric(15, 2)