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)
