Re: ALTER TABLE & NOT NULL - Mailing list pgsql-general

Thomas T. Thai wrote:
> How do you alter a column so that it uses NOT NULL? I tried:
>
> alter table auth_users alter email set default not null;
>
> ERROR:  Column "email" is of type character varying but default expression
> is of type boolean
>         You will need to rewrite or cast the expression
>

I think you have to add a table constraint to do that. Something like:

ALTER TABLE auth_users ADD CONSTRAINT auth_users_email CHECK (email is
not null);

Joe