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 [EMAIL PROTECTED])