The following bug has been logged online:
Bug reference: 3542
Logged by: Jens Schicke
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
