Index: openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d9-5.2.0d10.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d9-5.2.0d10.sql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d9-5.2.0d10.sql	6 Jan 2005 16:52:25 -0000	1.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/upgrade/upgrade-5.2.0d9-5.2.0d10.sql	15 Jul 2005 14:40:48 -0000	1.1.2.1
@@ -217,6 +217,10 @@
   delete from cr_release_periods
     where item_id = delete__item_id;
 
+
+  raise NOTICE ''Unsetting live and latest revisions...'';
+  update cr_items set live_revision = null, latest_revision = null where item_id = delete__item_id;
+
   raise NOTICE ''Deleting associated revisions...'';
   -- 3) delete all revisions of this item
   delete from cr_item_publish_audit