Index: openacs-4/packages/theme-selva/sql/postgresql/theme-selva-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/theme-selva/sql/postgresql/theme-selva-drop.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/theme-selva/sql/postgresql/theme-selva-drop.sql 18 Sep 2005 11:43:28 -0000 1.2 +++ openacs-4/packages/theme-selva/sql/postgresql/theme-selva-drop.sql 3 Mar 2006 13:53:27 -0000 1.2.2.1 @@ -1,13 +1,13 @@ UPDATE apm_parameter_values SET attr_value = '/packages/dotlrn/www/dotlrn-master' WHERE parameter_id IN (SELECT parameter_id FROM apm_parameters WHERE parameter_name='DefaultMaster'); UPDATE portals SET theme_id = (SELECT theme_id FROM portal_element_themes WHERE name LIKE '%sloan%'); -DELETE FROM portal_element_themes WHERE name = 'selva'; create function inline_0 () returns integer as ' declare theme portal_element_themes.theme_id%TYPE; begin SELECT theme_id INTO theme FROM portal_element_themes WHERE name=''selva''; + DELETE FROM portal_element_themes WHERE theme_id = theme; perform acs_object__delete(theme); return 0;