Index: openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql	18 Dec 2005 06:23:30 -0000	1.4
+++ openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql	18 Dec 2005 11:19:28 -0000	1.5
@@ -65,6 +65,13 @@
      </querytext>
    </fullquery>
 
+   <fullquery name="curriculum_central::uos::go_live::do_side_effect.set_live_revision">
+     <querytext>
+       UPDATE cc_uos SET live_revision_id = :latest_revision
+           WHERE uos_id = :object_id
+     </querytext>
+   </fullquery>
+
    <partialquery name="curriculum_central::uos::get_unit_coordinator::get_subquery.unit_coordinator_subquery">
      <querytext>
        (select * from cc_users u, cc_staff s where u.user_id = s.staff_id)
Index: openacs-4/packages/curriculum-central/tcl/uos-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/tcl/uos-procs.tcl,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/curriculum-central/tcl/uos-procs.tcl	18 Dec 2005 06:23:30 -0000	1.6
+++ openacs-4/packages/curriculum-central/tcl/uos-procs.tcl	18 Dec 2005 11:19:28 -0000	1.7
@@ -627,4 +627,7 @@
     # Set the latest revision as the live revision for the given
     # content item (object_id).
     content::item::set_live_revision -revision_id $latest_revision
+
+    # Also set the latest revision to the live revision in cc_uos.
+    db_dml set_live_revision {}
 }