Index: openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql,v diff -u -r1.1.2.2 -r1.1.2.3 --- openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql 23 Aug 2004 17:30:06 -0000 1.1.2.2 +++ openacs-4/packages/file-storage/sql/oracle/upgrade/upgrade-5.1.0a6-5.1.0a7.sql 10 Feb 2005 21:23:23 -0000 1.1.2.3 @@ -45,8 +45,7 @@ update cr_revisions set title=v_item_row.name where revision_id=v_item_row.revision_id; - if v_item_row.parent_id = v_prev_parent_id - and v_item_row.title = v_prev_title then + if (select 1 from cr_items where name=v_item_row.title and parent_id = v_item_row.parent_id) then --Name collision: change file.ext to file.n.ext