Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.62 -r1.63
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	13 Jan 2005 13:55:12 -0000	1.62
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	24 Feb 2005 19:34:26 -0000	1.63
@@ -1303,6 +1303,9 @@
   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