Index: openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql,v
diff -u -r1.25.2.10 -r1.25.2.11
--- openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql	19 Aug 2004 19:21:53 -0000	1.25.2.10
+++ openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql	7 Sep 2004 20:44:27 -0000	1.25.2.11
@@ -167,6 +167,13 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="fs::publish_versioned_object_to_file_system.select_file_name">
+        <querytext>
+            select filename
+            from cr_revisions
+            where revision_id = :live_revision
+        </querytext>
+    </fullquery>
   
     <fullquery name="fs::get_item_id.get_item_id">
       <querytext>
Index: openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql,v
diff -u -r1.38.2.4 -r1.38.2.5
--- openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	9 Aug 2004 21:48:37 -0000	1.38.2.4
+++ openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	7 Sep 2004 20:44:27 -0000	1.38.2.5
@@ -153,6 +153,14 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="fs::publish_versioned_object_to_file_system.select_file_name">
+        <querytext>
+            select content
+            from cr_revisions
+            where revision_id = :live_revision
+        </querytext>
+    </fullquery>
+
     <fullquery name="fs::get_item_id.get_item_id">
       <querytext>
         select content_item__get_id ( :name, :folder_id, 'f' )
Index: openacs-4/packages/file-storage/tcl/file-storage-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs.xql,v
diff -u -r1.15.2.3 -r1.15.2.4
--- openacs-4/packages/file-storage/tcl/file-storage-procs.xql	2 Aug 2004 19:56:00 -0000	1.15.2.3
+++ openacs-4/packages/file-storage/tcl/file-storage-procs.xql	7 Sep 2004 20:44:27 -0000	1.15.2.4
@@ -109,14 +109,6 @@
         </querytext>
     </fullquery>
 
-    <fullquery name="fs::publish_versioned_object_to_file_system.select_file_name">
-        <querytext>
-            select content
-            from cr_revisions
-            where revision_id = :live_revision
-        </querytext>
-    </fullquery>
-
     <fullquery name="fs::add_file.item_exists">
       <querytext>
           select count(*) from cr_items