Index: openacs-4/packages/acs-content-repository/tcl/content-revision-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/content-revision-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-content-repository/tcl/content-revision-procs-postgresql.xql	4 Jun 2006 00:45:23 -0000	1.4
+++ openacs-4/packages/acs-content-repository/tcl/content-revision-procs-postgresql.xql	27 Aug 2006 20:34:37 -0000	1.5
@@ -60,4 +60,14 @@
       </querytext>
   </fullquery>
 
+  <fullquery name="content::revision::get_cr_file_path.get_storage_key_and_path">
+    <querytext>	
+      select storage_area_key, 
+        content as filename
+      from cr_items ci, 
+        cr_revisions cr 
+      where cr.item_id=ci.item_id 
+        and cr.revision_id=:revision_id
+    </querytext>
+  </fullquery>
 </queryset>