BUG #3542: Dropped and recreated columns have problems with NOT NULL contraints - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      3542
Logged by:          Jens Schicke
Email address:      j.schicke@asco.de
PostgreSQL version: 8.2.4
Operating system:   GNU/Linux
Description:        Dropped and recreated columns have problems with NOT
NULL contraints
Details:

pizza_de=# alter table store_flags add column flag integer;
ALTER TABLE
pizza_de=# alter table store_flags drop column flag;
ALTER TABLE
pizza_de=# alter table store_flags add column flag integer not null;
ERROR:  column "flag" contains null values
pizza_de=# alter table store_flags drop column flag;
ERROR:  column "flag" of relation "store_flags" does not exist
pizza_de=# alter table store_flags add column flag integer not null;
ERROR:  column "flag" contains null values