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