Index: openacs-4/packages/fs-portlet/sql/postgresql/upgrade/upgrade-2.0.3-2.0.4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/fs-portlet/sql/postgresql/upgrade/upgrade-2.0.3-2.0.4.sql,v diff -u -r1.1.2.3 -r1.1.2.4 --- openacs-4/packages/fs-portlet/sql/postgresql/upgrade/upgrade-2.0.3-2.0.4.sql 7 Sep 2004 15:28:01 -0000 1.1.2.3 +++ openacs-4/packages/fs-portlet/sql/postgresql/upgrade/upgrade-2.0.3-2.0.4.sql 13 Sep 2004 14:14:01 -0000 1.1.2.4 @@ -14,17 +14,17 @@ row_res record; begin - if :old.label <> :new.label then + if old.label <> new.label then for row_res in select m.element_id from portal_element_map m, portal_element_parameters p where p.key = "folder_id" - and p.value = :new.folder_id + and p.value = new.folder_id and m.element_id = p.element_id and m.name = "fs_contents_portlet" loop update portal_element_map - set pretty_name = :new.label + set pretty_name = new.label where element_id = row_res.element_id; end loop;