On Dec 5, 2005, at 2:25 PM, Allen Gilliland wrote:
i just tried the upgrade script on hsql and it didn't work properly.
hsql complained about the "alter table foo alter" lines.
is there a reason why we are doing it in multiple lines rather than in
a
single line? i.e.
Yes. PostgreSQL won't accept the one liner.
i currently see ...
alter table roller_comment add column approved bit;
alter table roller_comment alter approved set default 1;
alter table roller_comment alter approved set not null;
and i had to manually change that to ...
alter table roller_comment add column approved bit default 1 not null;
in any case, i can see that by properly defining the addColumn() macro
it should make the process a bit easier.
Yeah, I've got to get that macro right.
- Dave
