Re: [BUGS] alter table rename missing numeric type

2000-12-03 Thread Tom Lane
> 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

[BUGS] alter table rename missing numeric type

2000-12-03 Thread pgsql-bugs
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