Postgres throwing exception for int8 datatype. - Mailing list pgsql-bugs

From Niranjan Shivaratri
Subject Postgres throwing exception for int8 datatype.
Date
Msg-id EA23924D8B48774F889C7733226B28E8A5926D@exalane.intransa.com
Whole thread Raw
Responses Re: Postgres throwing exception for int8 datatype.
Re: Postgres throwing exception for int8 datatype.
List pgsql-bugs
I am running postgres 7.1 version on a Mips platform running Linux (2.4.17s=
b20020611 version).
The postgres source is compiled with Montevista cross compiler (gcc version=
 3.0.1) for the mips platform.=20


Postgres is throwing following exception when a record is inserted with int=
8 datatype. Note that, according to the=20
documentation, int8 is signed eight-byte integer.=20

The value '1027103669840' is well below the max range of int8.
This problem does not happen on X86 platform.=20


 DBM:ExceptionDB: SQL:INSERT INTO PerfCpuSample VALUES ('1027103669840','sb=
1test','0.0452452')
=20
 ExceptionDB: ERROR:  int8 value out of range: "1027103669840"
 DBM:ExceptionDB: CODE =3D 5.


Any help is appreciated very much.

Thanks very much.=20

Niranjan.=20

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_ctl failure with older Bourne shells (use ${1:+"$@"})
Next
From: "Pankaj Naug"
Date:
Subject: help