Skip site navigation (1) Skip section navigation (2)

bigint and int8 bug on postgres version 7.2 database.

From: Vicky(dot)Pan(at)bmsus(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: bigint and int8 bug on postgres version 7.2 database.
Date: 2002-04-17 16:38:02
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
Dear Bug Killer,

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

1.When I inserted data with an integer less than or equal to 10 digit, it
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

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


pgsql-bugs by date

Next:From: Matt OlsonDate: 2002-04-17 18:04:49
Subject: FATAL 2: XLogWrite: write request 3/39000000 is past end of log 3/38FC2000 (fwd)
Previous:From: Rod TaylorDate: 2002-04-17 02:29:10
Subject: Re: [BUGS] Foreign Key woes -- 7.2 and ~7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group