Index: openacs-4/packages/lars-blogger/sql/oracle/upgrade/upgrade-0.8.5-0.9.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/oracle/upgrade/Attic/upgrade-0.8.5-0.9.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/lars-blogger/sql/oracle/upgrade/upgrade-0.8.5-0.9.sql 13 Jun 2003 13:51:00 -0000 1.1.2.1 +++ openacs-4/packages/lars-blogger/sql/oracle/upgrade/upgrade-0.8.5-0.9.sql 16 Jun 2003 15:46:47 -0000 1.1.2.2 @@ -107,3 +107,26 @@ end weblogger_channel; / show errors + +-- Remove the new parameter rss_file_name and update the old one +-- We do this since the APM does not know that the old parameter +-- has been replaced and we want to retain the values of the old parameter +declare + v_parameter_id integer; +begin + + select parameter_id into v_parameter_id + from apm_parameters + where parameter_name = 'rss_file_name'; + + select apm.unregister_parameter(v_parameter_id) from dual; + +end; +/ +show errors + +update apm_parameters + set parameter_name = 'rss_file_name', + description = 'What name should we advertise the RSS feed under, relative to the blog mount point. Leave blank if no RSS feed.', + default_value = 'rss.xml' + where parameter_name = 'rss_file_url'; Index: openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-0.8.5-0.9.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/upgrade/Attic/upgrade-0.8.5-0.9.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-0.8.5-0.9.sql 13 Jun 2003 13:51:00 -0000 1.1.2.1 +++ openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-0.8.5-0.9.sql 16 Jun 2003 15:46:48 -0000 1.1.2.2 @@ -149,3 +149,29 @@ return 0; end; ' language 'plpgsql'; + +-- Remove the new parameter rss_file_name and update the old one +-- We do this since the APM does not know that the old parameter +-- has been replaced and we want to retain the values of the old parameter +create function inline_0 () +returns integer as ' +declare + v_parameter_id integer; +begin + select parameter_id into v_parameter_id + from apm_parameters + where parameter_name = ''rss_file_name''; + + perform apm__unregister_parameter(v_parameter_id); + + return 0; +end; +' language 'plpgsql'; +select inline_0 (); +drop function inline_0 (); + +update apm_parameters + set parameter_name = 'rss_file_name', + description = 'What name should we advertise the RSS feed under, relative to the blog mount point. Leave blank if no RSS feed.', + default_value = 'rss.xml' + where parameter_name = 'rss_file_url';