Index: openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql,v
diff -u -r1.11.2.6 -r1.11.2.7
--- openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql	23 Apr 2024 14:43:30 -0000	1.11.2.6
+++ openacs-4/packages/acs-content-repository/tcl/revision-procs-postgresql.xql	31 May 2024 13:10:05 -0000	1.11.2.7
@@ -2,6 +2,14 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
+<fullquery name="cr_write_content-file.write_file_content">
+      <querytext>
+          select :path || content
+          from cr_revisions
+          where revision_id = :revision_id
+      </querytext>
+</fullquery>
+
 <fullquery name="cr_write_content-lob.write_lob_content">
       <querytext>
           select lob as content, 'lob' as storage_type