Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group