Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE

On Wed, 2004-10-20 at 14:07, Tom Lane wrote:
> "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> > troels=# create table lookat_feature(
> > troels(# feature_id char(4),
> > troels(# status varchar(2) default 'TODO'

> The alternative would seem to be decreeing that this is not a bug.
>
> Comments anyone?

I think the bug is that default takes a value which does not fit the
columns data type.

bric=# create table test (col numeric(6,2) DEFAULT '1023456632');
CREATE TABLE
bric=# insert into test default values;
ERROR: numeric field overflow
DETAIL: The absolute value is greater than or equal to 10^9 for field
with precision 6, scale 2.