Steve Dunham <dunham@cse.msu.edu> writes:
>>> Oliver Elphick <olly@lfix.co.uk> writes:
> com.pany=# insert into foo values (1034784236789);
> ERROR: Floating point conversion to int8 is out of range
> The problem is that libcrypto.so has an unresolved symbol on Debian
> and this is making the "long long int is 64bit" test fail in configure
> fail, so it thinks long long is not 64bit.
Ah so.
> I don't know if this is the way postgresql is supposed to behave on
> platforms with no 64-bit integer; if not, there is a postgresql bug
> here.
No, that is the expected behavior: "int8" is effectively int4, and so
the above value in fact is out of range for "int8".
regards, tom lane