numeric type issue

--_000_8C3F6C3393513F4BAFA2D95D662927231D0CCB6FC1EXVMBX0202e xc_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 valu=
es, 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 u=
se 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






--_000_8C3F6C3393513F4BAFA2D95D662927231D0CCB6FC1EXVMBX0202e xc_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

Re: 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


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: numeric type issue

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]=20
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,
>=20
>
>=20
> I'm trying to migrate postgres 7.4 to postgres 8.4.2-1. Everything=20
> seems to work fine, but fields in database with NUMERIC type returning=20
> wrong values, but in the tables they are correct.
>=20
>
>=20
> For example: I have column defined like this:
>=20
> charge numeric(7,2) DEFAULT 0 NOT NULL,NOT NULL with value 6.67.
>=20
>
>=20
> If I use psqlODBC version 08.04.0100 return value would be 6.00, but if=
=20
> I use driver postgresql-odbc-08.03.0400-1PGDG.rhel5 return value is 6.67=
=20
> which is how it suppose to be.
>=20
>
>=20
> Does anybody know any issues with version 08.04.0100 regarding numeric=20
> type ?=20

This bug was fixed in 8.4.0200.

regards,
Hiroshi Inoue


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: numeric type issue

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


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc