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 -r1.2 -r1.3
--- openacs-4/packages/cms/tcl/publish-procs-postgresql.xql	28 Aug 2001 23:31:30 -0000	1.2
+++ openacs-4/packages/cms/tcl/publish-procs-postgresql.xql	30 Aug 2001 01:46:05 -0000	1.3
@@ -7,7 +7,9 @@
       <querytext>
 
       select case when i.storage_type = 'file' 
-                       then '[cr_fs_path]' || r.content 
+                       then '[cr_fs_path]' || r.content
+                  when i.storage_type = 'lob'
+                       then lob::text 
                        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