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
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' |