Re: Bug/Change in behavior for 7.3 vs 7.2.1

Dang it...meant to mention that the other day when I was working on
those python patches.  I had to place tick marks (single quote) around
the number and it was converted correctly.

gcope=# insert into a values ( 9999999999 ) ;
ERROR:  column "a" is of type 'bigint' but expression is of type 'double
precision'You will need to rewrite or cast the expression
gcope=# insert into a values ( '9999999999' ) ;
INSERT 25115 1

Greg


On Thu, 2002-08-15 at 20:03, Barry Lind wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)