Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	16 Oct 2001 01:36:19 -0000	1.8
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	30 Oct 2001 05:15:22 -0000	1.9
@@ -753,10 +753,9 @@
 begin
         insert into cr_files_to_delete (
           path, storage_area_key
-        ) select content.blob_to_string(r.content), i.storage_area_key
-            from cr_items i, cr_revisions r
-           where i.item_id = r.item_id
-             and r.revision_id = :old.revision_id
+        ) select content.blob_to_string(:old.content), i.storage_area_key
+            from cr_items i
+           where i.item_id = :old.item_id
              and i.storage_type = 'file';
 
 end cr_cleanup_cr_files_del_trg;