Thread: numeric type issue
Hi,
I'm trying to migrate postgres 7.4 to postgres 8.4.2-1. Everything seems to work fine, but fields in database with NUMERIC type returning wrong values, but in the tables they are correct.
For example: I have column defined like this:
charge numeric(7,2) DEFAULT 0 NOT NULL,NOT NULL with value 6.67.
If I use psqlODBC version 08.04.0100 return value would be 6.00, but if I use driver postgresql-odbc-08.03.0400-1PGDG.rhel5 return value is 6.67 which is how it suppose to be.
Does anybody know any issues with version 08.04.0100 regarding numeric type ? . Would it be safe to use postgresql-odbc-08.03.0400-1PGDG.rhel5 driver with 8.4.2-1 postgres?
Thanks
-Valdas
Valdas Rutkauskas wrote: > Hi, > > > > I'm trying to migrate postgres 7.4 to postgres 8.4.2-1. Everything > seems to work fine, but fields in database with NUMERIC type returning > wrong values, but in the tables they are correct. > > > > For example: I have column defined like this: > > charge numeric(7,2) DEFAULT 0 NOT NULL,NOT NULL with value 6.67. > > > > If I use psqlODBC version 08.04.0100 return value would be 6.00, but if > I use driver postgresql-odbc-08.03.0400-1PGDG.rhel5 return value is 6.67 > which is how it suppose to be. > > > > Does anybody know any issues with version 08.04.0100 regarding numeric > type ? This bug was fixed in 8.4.0200. regards, Hiroshi Inoue
Thanks! Do you know if this bug is only for *nix version ? We using this driver in windows and do not see isue there. -----Original Message----- From: Hiroshi Inoue [mailto:inoue@tpf.co.jp] Sent: Monday, February 15, 2010 6:49 PM To: Valdas Rutkauskas Cc: pgsql-odbc@postgresql.org Subject: Re: [ODBC] numeric type issue Valdas Rutkauskas wrote: > Hi, > > > > I'm trying to migrate postgres 7.4 to postgres 8.4.2-1. Everything > seems to work fine, but fields in database with NUMERIC type returning > wrong values, but in the tables they are correct. > > > > For example: I have column defined like this: > > charge numeric(7,2) DEFAULT 0 NOT NULL,NOT NULL with value 6.67. > > > > If I use psqlODBC version 08.04.0100 return value would be 6.00, but if > I use driver postgresql-odbc-08.03.0400-1PGDG.rhel5 return value is 6.67 > which is how it suppose to be. > > > > Does anybody know any issues with version 08.04.0100 regarding numeric > type ? This bug was fixed in 8.4.0200. regards, Hiroshi Inoue
Valdas Rutkauskas wrote: > Thanks! > > Do you know if this bug is only for *nix version ? We using this driver in windows and do not see isue there. This bug doesn't exist in Windows version. regards, Hiroshi Inoue > -----Original Message----- > From: Hiroshi Inoue [mailto:inoue@tpf.co.jp] > Sent: Monday, February 15, 2010 6:49 PM > To: Valdas Rutkauskas > Cc: pgsql-odbc@postgresql.org > Subject: Re: [ODBC] numeric type issue > > Valdas Rutkauskas wrote: >> Hi, >> >> >> >> I'm trying to migrate postgres 7.4 to postgres 8.4.2-1. Everything >> seems to work fine, but fields in database with NUMERIC type returning >> wrong values, but in the tables they are correct. >> >> >> >> For example: I have column defined like this: >> >> charge numeric(7,2) DEFAULT 0 NOT NULL,NOT NULL with value 6.67. >> >> >> >> If I use psqlODBC version 08.04.0100 return value would be 6.00, but if >> I use driver postgresql-odbc-08.03.0400-1PGDG.rhel5 return value is 6.67 >> which is how it suppose to be. >> >> >> >> Does anybody know any issues with version 08.04.0100 regarding numeric >> type ? > > This bug was fixed in 8.4.0200. > > regards, > Hiroshi Inoue