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

Pg 7.2.3 int8 value out of range

From: Brian Macy <bmacy(at)macykids(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Pg 7.2.3 int8 value out of range
Date: 2002-10-17 17:47:20
Message-ID: 3DAEF7A8.5070204@macykids.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Only excepts 32bit values and not 64bit. Endian issue?

This is on sparc linux.

com.pany=# create table foo (val bigint);
CREATE
com.pany=# insert into foo values (1034784236789);
ERROR:  Floating point conversion to int8 is out of range
com.pany=# insert into foo values (103478423678);
ERROR:  Floating point conversion to int8 is out of range
com.pany=# insert into foo values (10347842367);
ERROR:  Floating point conversion to int8 is out of range
com.pany=# insert into foo values (1034784236);
INSERT 16872 1

I also got this on a restore with inserts from a remote machine.
psql:restore.sql:124576: ERROR:  int8 value out of range:
"1033219132976"
psql:restore.sql:124577: ERROR:  int8 value out of range:
"1033217951899"
psql:restore.sql:124578: ERROR:  int8 value out of range:
"1033220352916"
psql:restore.sql:124579: ERROR:  int8 value out of range:
"1033217955384"


Brian Macy



Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-10-18 01:28:09
Subject: Re: Pg 7.2.3 int8 value out of range
Previous:From: Nicolaus ErichsenDate: 2002-10-17 15:06:36
Subject: Issues with german 'Umlaute'

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