Re: Changing column constraints?

Henry,

> If I have a column constraint:
>     addr_type char( 10 ) default 'street'
>     CHECK( addr_type = 'street' || addr_type = 'pobox' ),
> in a table, how can I add another choice to the list after I've
>  already
> entered data into the table?

Three options:

One, drop and rebuild the table with the constraint modified.  Sorry,but until we have ALTER CONSTRAINT implemented,
thisis the onlysimple way to modify and exisiting constraint.
 

Two, mess with system tables to alter the constraint.  I do notreccomend this.

Three, drop and re-build the table, and this time do it right: havecolumn addr_type reference another table called
"addr_types"that listthe acceptable type values.  Then use a foriegn key to enforce this.
 

-Josh Berkus