ALTER TABLE ADD COLUMN can't use NOT NULL?

From: Bradley McLean <brad(at)bradm(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: ALTER TABLE ADD COLUMN can't use NOT NULL?
Date: 2001-11-12 16:32:05
Message-ID: 20011112113205.A5838@bradm.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-11-12 16:36:54 Re: Open items
Previous Message Jorge Sarmiento 2001-11-12 16:09:01 Re: psql -f backup.out || file too big - SOLVED