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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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