Pg 7.2.3 int8 value out of range
От | Brian Macy |
---|---|
Тема | Pg 7.2.3 int8 value out of range |
Дата | |
Msg-id | 3DAEF7A8.5070204@macykids.net обсуждение исходный текст |
Ответы |
Re: Pg 7.2.3 int8 value out of range
|
Список | 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
В списке pgsql-bugs по дате отправления: