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 -r1.2.2.1 --- openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql 7 Aug 2017 23:47:47 -0000 1.2 +++ openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql 13 Mar 2019 10:18:04 -0000 1.2.2.1 @@ -33,7 +33,7 @@ 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 + where r.item_id = i.item_id and r.revision_id = :revision_id