Index: openacs-4/packages/cms/tcl/publish-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/publish-procs-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/cms/tcl/publish-procs-postgresql.xql	11 Aug 2001 17:41:34 -0000	1.1
+++ openacs-4/packages/cms/tcl/publish-procs-postgresql.xql	28 Aug 2001 23:31:30 -0000	1.2
@@ -6,7 +6,11 @@
 <fullquery name="publish::write_multiple_blobs.wmb_get_blob_file">      
       <querytext>
 
-      select content from cr_revisions where revision_id = $revision_id
+      select case when i.storage_type = 'file' 
+                       then '[cr_fs_path]' || r.content 
+                       else r.content end as content, i.storage_type 
+      from cr_revisions r, cr_items i 
+      where r.item_id = i.item_id and r.revision_id = $revision_id
     
       </querytext>
 </fullquery>