> template1=> insert into n2 values(154.23);
> INSERT 360703 1
> template1=> alter table n1 rename to oldn1;
> RENAME
> template1=> alter table n2 rename to n1;
> RENAME
> template1=> insert into n1 values(154.23);
> ERROR: overflow on numeric ABS(value) >= 10^2 for field with precision 4 scale 2
Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
alter table rename missing numeric type
Long Description
I start with table n1 which contains only a numeric type 4,2. Inserting a value
larger than 99.99 causes