bigint disparity between two installations

From: "Tony Sullivan" <tony(at)exquisiteimages(dot)com>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: bigint disparity between two installations
Date: 2018-04-24 12:58:59
Message-ID: 61ea10a0c288c29126174ae0302b2254.squirrel@www.exquisiteimages.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I have a database on PostgreSQL 9.3 that I am accessing using psqlodbc
version 9.03.04.00 on a couple of different Windows machines.

I have some bigint fields that are truncated on only one of the machines.
I have called both of their odbc setups up and compared them screen by
screen a few times and they are setup the same.

A value that is stored in the database is: -40581311272
This value is read correctly on two of the machines, but is returned as
-405813112 on the third. I have tried different options for int8 on that
installation and none returns the full value.

Does anyone have an idea as to what the issue might be here?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Clemens Ladisch 2018-04-24 16:48:06 Re: bigint disparity between two installations
Previous Message Inoue, Hiroshi 2018-04-24 06:06:18 Re: Registering DSN with odbcconf.exe overwrites the connection attributes with defaults