Hello,
I am triying to install the alpha 6 with postgres but the upgrading schemas does not work. The problem is that the statement to alter the table is not valid (at least for 7.4.7 version) because it tries to do three actions in a single stament (add a column, set the default value and set the not null constraint). In order to upgrade the database yoy need three statements for each one. Here is an example:
this stament:
alter table sysmaps_hosts add icon_on varchar(32) SET DEFAULT 'Server' SET NOT NULL;
is changed for these four:
alter table sysmaps_hosts add icon_on varchar(32);
alter table sysmaps_hosts add icon_on SET DEFAULT 'Server';
update sysmaps_hosts set icon_on='icon';
alter table sysmaps_hosts add icon_on SET NOT NULL;
Also there is another small mistake, the type blob is in fact bytea.
The question are ... Is this an overlook or I need to upgrade to postgresql 8.0?
Is anyone using the alpha version with postgresql who does not mind tell the experience?
Thanx.
I am triying to install the alpha 6 with postgres but the upgrading schemas does not work. The problem is that the statement to alter the table is not valid (at least for 7.4.7 version) because it tries to do three actions in a single stament (add a column, set the default value and set the not null constraint). In order to upgrade the database yoy need three statements for each one. Here is an example:
this stament:
alter table sysmaps_hosts add icon_on varchar(32) SET DEFAULT 'Server' SET NOT NULL;
is changed for these four:
alter table sysmaps_hosts add icon_on varchar(32);
alter table sysmaps_hosts add icon_on SET DEFAULT 'Server';
update sysmaps_hosts set icon_on='icon';
alter table sysmaps_hosts add icon_on SET NOT NULL;
Also there is another small mistake, the type blob is in fact bytea.
The question are ... Is this an overlook or I need to upgrade to postgresql 8.0?
Is anyone using the alpha version with postgresql who does not mind tell the experience?
Thanx.
Comment