ALTER TABLE & NOT NULL

From: "Thomas T(dot) Thai" <tom(at)minnesota(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: ALTER TABLE & NOT NULL
Date: 2002-04-06 19:08:36
Message-ID: Pine.NEB.4.43.0204061307240.3329-100000@ns01.minnesota.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2002-04-06 19:28:59 Re: ALTER TABLE & NOT NULL
Previous Message Command Prompt, Inc. 2002-04-06 17:39:26 Re: Who's using PostgreSQL?