Ah yes.
ALTER TABLE blah ADD COLUMN whatever integer;
UPDATE blah set whatever=1;
ALTER TABLE blah ALTER COLUMN whatever SET NOT NULL;
Produces the desired effect.
I was thinking something along the lines of
ALTER TABLE blah ADD COLUMN whatever integer not null default 1;
should work, but the above is just as handy.
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
________________________________________________________________________