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).

[matt]

Again for formatting:

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;

[thomasb]

Fixed in r923