Index: openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql,v diff -u -r1.1.2.3 -r1.1.2.4 --- openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql 13 Sep 2004 17:49:47 -0000 1.1.2.3 +++ openacs-4/packages/file-storage/sql/postgresql/upgrade/upgrade-5.1.0a6-5.1.0a7.sql 10 Feb 2005 19:47:05 -0000 1.1.2.4 @@ -50,8 +50,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) then --Name collision: change file.ext to file.n.ext