Re: How to ALTER COLUMN to set a constraint of not null?

Jean-Christian Imbeault wrote:

> How does one add a "NOT NULL" constraint to a new column?

> JC=# alter table credit_card_names alter column number_length set
> default not null;
> ERROR:  Column "number_length" is of type smallint but default

ALTER TABLE [ ONLY ] table [ * ]
    ALTER [ COLUMN ] column { SET | DROP } NOT NULL

i.e.  alter table credit_card_names alter column number_length set not null;

--
Peter Gibbs
EmKel Systems