From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Robson Richieri" <rob-richieri(at)bol(dot)com(dot)br>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Error Message: ERROR: Bad numeric input format '-591,87' |
Date: | 2004-02-18 15:29:03 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B889F3D7@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | James M Doherty | 2004-02-18 19:24:46 | Re: connection dropping continued |
Previous Message | Robson Richieri | 2004-02-18 14:46:01 | Error Message: ERROR: Bad numeric input format '-591,87' |