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
