Re: Postgres throwing exception for int8 datatype.

Looks like an ODBC error. Is it? Have you tried the newest odbc at
odbc.postgresq.org?

---------------------------------------------------------------------------

Niranjan Shivaratri wrote:
> I am running postgres 7.1 version on a Mips platform running Linux (2.4.17sb20020611 version).
> The postgres source is compiled with Montevista cross compiler (gcc version 3.0.1) for the mips platform.
>
>
> Postgres is throwing following exception when a record is inserted with int8 datatype. Note that, according to the
> documentation, int8 is signed eight-byte integer.
>
> The value '1027103669840' is well below the max range of int8.
> This problem does not happen on X86 platform.
>
>
> DBM:ExceptionDB: SQL:INSERT INTO PerfCpuSample VALUES ('1027103669840','sb1test','0.0452452')
>
> ExceptionDB: ERROR: int8 value out of range: "1027103669840"
> DBM:ExceptionDB: CODE = 5.
>
>
> Any help is appreciated very much.
>
> Thanks very much.
>
> Niranjan.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026