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

Re: Postgres throwing exception for int8 datatype.

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Niranjan Shivaratri <niranjan(dot)shivaratri(at)intransa(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Postgres throwing exception for int8 datatype.
Date: 2002-07-23 21:58:36
Message-ID: 200207232158.g6NLwaO06585@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Looks like an ODBC error.  Is it?  Have you tried the newest odbc at
odbc.postgresq.org?


---------------------------------------------------------------------------

Niranjan Shivaratri wrote:
> 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
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-07-23 23:49:53
Subject: Re: pg_ctl -w option does not behave as documented
Previous:From: Dmitry TkachDate: 2002-07-23 16:55:33
Subject: JDBC timestamp does not understand [-]infinity

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