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: AFA417E2A564D41182A800508BAE3C48D4BBE7@usbage20.bmgmusic.us.bertelsmann.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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(dot)pan(at)bmsus(dot)com 



Responses

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-2014 The PostgreSQL Global Development Group