Skip site navigation (1) Skip section navigation (2)

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

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Troels Arvin <troels(at)arvin(dot)dk>, pgsql-bugs(at)postgresql(dot)org,PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] BUG #1290: Default value and ALTER...TYPE
Date: 2004-10-20 18:17:49
Message-ID: 1098296269.747.221.camel@home (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
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.




In response to

Responses

pgsql-hackers by date

Next:From: Troels ArvinDate: 2004-10-20 18:29:12
Subject: Re: BUG #1290: Default value and ALTER...TYPE
Previous:From: Tom LaneDate: 2004-10-20 18:07:29
Subject: Re: BUG #1290: Default value and ALTER...TYPE

pgsql-bugs by date

Next:From: Troels ArvinDate: 2004-10-20 18:29:12
Subject: Re: BUG #1290: Default value and ALTER...TYPE
Previous:From: Tom LaneDate: 2004-10-20 18:07:29
Subject: Re: BUG #1290: Default value and ALTER...TYPE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group