Postgres throwing exception for int8 datatype.

From: "Niranjan Shivaratri" <niranjan(dot)shivaratri(at)intransa(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Cc: "Niranjan Shivaratri" <niranjan(dot)shivaratri(at)intransa(dot)com>
Subject: Postgres throwing exception for int8 datatype.
Date: 2002-07-20 02:29:32
Message-ID: EA23924D8B48774F889C7733226B28E8A5926D@exalane.intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bradley Kieser 2002-07-20 16:57:26 PG 7.1: VIEW returns fewer rows than equivalent select
Previous Message Bruce Momjian 2002-07-19 15:32:41 Re: pg_ctl failure with older Bourne shells (use ${1:+"$@"})