> 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
I can't duplicate either part of this bug report, using either 7.0.2
or current sources. Something's pretty whacked out about your
installation I think... what version are you running, anyway?
BTW, you didn't actually show us the command you used to create n2.
regards, tom lane