Index: openacs-4/packages/acs-content-repository/tcl/publish-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/publish-procs-oracle.xql,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/acs-content-repository/tcl/publish-procs-oracle.xql 13 Mar 2019 10:17:14 -0000 1.2.2.1 +++ openacs-4/packages/acs-content-repository/tcl/publish-procs-oracle.xql 13 Mar 2019 10:18:47 -0000 1.2.2.2 @@ -4,48 +4,48 @@ oracle8.1.6 - + begin content_revision.to_temporary_clob(:revision_id); end; - + - + - select + select content - from + from cr_content_text - where + where revision_id = :revision_id - + select [expr {$storage_type eq "file" ? "'[cr_fs_path]' || filename" : "content"}] from cr_revisions where revision_id = :revision_id - + - - select + + select content - from + from cr_content_text - where + where revision_id = :revision_id - + - + Index: openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql 13 Mar 2019 10:18:04 -0000 1.2.2.1 +++ openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql 13 Mar 2019 10:18:47 -0000 1.2.2.2 @@ -3,52 +3,52 @@ postgresql7.1 - + select 1 - + - select + select content - from + from cr_revisions - where + where revision_id = :revision_id - + - select case when i.storage_type = 'file' + select case when i.storage_type = 'file' 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 + 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 - + - - select + + select content - from + from cr_revisions - where + where revision_id = :revision_id - + - +