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: (view raw, whole thread or download thread mbox)
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. 



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-2017 The PostgreSQL Global Development Group