ALTER TABLE ADD COLUMN can't use NOT NULL? - Mailing list pgsql-hackers

From Bradley McLean
Subject ALTER TABLE ADD COLUMN can't use NOT NULL?
Date
Msg-id 20011112113205.A5838@bradm.net
Whole thread Raw
Responses Re: ALTER TABLE ADD COLUMN can't use NOT NULL?
Re: ALTER TABLE ADD COLUMN can't use NOT NULL?
List pgsql-hackers
In the CVS tip from this morning:

a123=# alter table test add test1 int4 not null;
ERROR:  Adding NOT NULL columns is not implemented.       Add the column, then use ALTER TABLE ADD CONSTRAINT.
a123=# alter table test add test1 int4 null;
ALTER
a123=#

I'm pretty sure the first one used to work just fine.  Is this
intentional breakage?

-Brad


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Open items
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ADD COLUMN can't use NOT NULL?