Bug/Change in behavior for 7.3 vs 7.2.1

From: Barry Lind <barry(at)xythos(dot)com>
To: PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug/Change in behavior for 7.3 vs 7.2.1
Date: 2002-08-16 01:03:03
Message-ID: 3D5C4F47.6050606@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was just testing my product running on a 7.3 snapshot from a few days
ago. And I ran into the following change in behavior that I consider a
bug. You can no long insert large values into a bigint column without a
cast. Small values (in the int range work fine though).

On 7.3 I get:

files=# create table test (cola bigint);
CREATE
files=# insert into test values (9999999999);
ERROR: column "cola" is of type 'bigint' but expression is of type
'double precision'
You will need to rewrite or cast the expression

On 7.2.1 this works correctly:

files=# create table test (cola bigint);
CREATE
files=# insert into test values (9999999999);
INSERT 108683 1

thanks,
--Barry

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-08-16 01:12:02 Re: Open 7.3 items
Previous Message Robert Treat 2002-08-15 23:14:50 Re: [HACKERS] Companies involved in development