Alter table not correct for Postgres 8.0+

[Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>]

If I try to add a column that is not null with a default the SQL that 
gets generated is:

ALTER TABLE control
   ADD COLUMN security_options int;
ALTER TABLE control
   ALTER COLUMN security_options SET NOT NULL;
ALTER TABLE control
   ALTER COLUMN security_options SET DEFAULT 32;

This generates an error if the table already contains rows.

Whereas from 8.0 the following will work and ought to be used instead:

ALTER TABLE control
   ADD COLUMN security_options int not null default 32;


Thanks,
Gary.