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 -N -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 - + - +