id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
1484668,Postgresql upgrade script syntax isn't valid for ALTER TABLE,matt,,"The update script in 1.0rc2 has:
ALTER TABLE ""identities"" ADD html_signature integer DEFAULT 0 NOT NULL;

except that syntax isn't valid (at least for 7.4 that I'm using). Something better might be:

ALTER TABLE ""identities"" ADD html_signature;
ALTER TABLE ""identities"" ALTER html_signature SET DEFAULT 0;
UPDATE identities SET html_signature = 0;
ALTER TABLE ""identities"" ALTER html_signature SET NOT NULL;

(the required UPDATE is a bit ugly, not sure a better way).


",Bugs,closed,4,0.1-stable,Database,0.1-rc2,normal,fixed,,