ALTER TABLE & NOT NULL - Mailing list pgsql-general

From Thomas T. Thai
Subject ALTER TABLE & NOT NULL
Date
Msg-id Pine.NEB.4.43.0204061307240.3329-100000@ns01.minnesota.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: "Command Prompt, Inc."
Date:
Subject: Re: Who's using PostgreSQL?
Next
From: Joe Conway
Date:
Subject: Re: ALTER TABLE & NOT NULL