Обсуждение: bigint and int8 bug on postgres version 7.2 database.

Dear Bug Killer,

    I created table xxxx with int8/bigint columns in postgres version 7.2
database.

1.When I inserted data with an integer less than or equal to 10 digit, it
ok.
But when I inserted data with an integer more than 10 digit I got following
error massage:

ERROR:  Floating point conversion to int8 is out of range.


2. When I using 'COPY xxxx from xxxxxxx', if the integer data are less than
10 digit, it fine,
But when the integer data more than 10 digit,  I also got following error
message:

ERROR:  copy: line 1, int8 value out of range: "1002002000041652"

It seems that on the 7.2 version, datatype int8/bigint is the same as
integer/int4.
This problem is not exist on the postgres version 7.1 database we are using,
only exist on the version 7.2 database.

    Thank you.




Vicky Pan
Database Administrator
Bertelsmann mediaSystems NA
______________________________________________

Bertelsmann, Inc. | 1540 Broadway | New York, NY 10036
Phone (212) 782 - 0345 | Fax (212) 782 - 0358
mailto:vicky.pan@bmsus.com

Vicky.Pan@bmsus.com writes:
> [ strange behavior ]

What do you get from a simple

    select 123456789012345::int8;

What platform are you on, what compiler, etc?  It sounds like configure
decided that you didn't have any int8 support available ...

            regards, tom lane