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