The iDocs state that:
"In the current implementation of ADD COLUMN, default and NOT NULL
clauses for the new column are not supported. You can use the SET
DEFAULT form of ALTER TABLE to set the default later."
How does one add a "NOT NULL" constraint to a new column? I've tried
this but with no success:
JC=# alter table credit_card_names add column number_length int2;
ALTER TABLE
JC=# alter table credit_card_names alter column number_length set
default not null;
ERROR: Column "number_length" is of type smallint but default
expression is of type boolean
You will need to rewrite or cast the expression
Jc