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.23 -r1.24
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	16 Jul 2001 23:46:08 -0000	1.23
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	23 Aug 2001 02:26:21 -0000	1.24
@@ -1074,6 +1074,7 @@
     --        first.  I suspect that it is not functioning correctly.
 
     while v_parent_id = v_rel_parent_id LOOP
+        -- c_abs_cur
         select 
            name, parent_id, tree_level(tree_sortkey)
         into 
@@ -1091,6 +1092,7 @@
           v_item_id := v_parent_id;
         end if;
         
+        -- c_rel_cur
         select 
           parent_id, tree_level(tree_sortkey) as tree_level
         into 
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql,v
diff -u -r1.23 -r1.24
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	14 Jun 2001 12:52:01 -0000	1.23
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-revision.sql	23 Aug 2001 02:26:21 -0000	1.24
@@ -360,10 +360,9 @@
       if NOT FOUND then
          v_latest_revision := null;        
       end if;
-      if v_latest_revision != delete__revision_id then 
-            update cr_items set latest_revision = v_latest_revision
-            where item_id = v_item_id;
-      end if;
+      
+      update cr_items set latest_revision = v_latest_revision
+      where item_id = v_item_id;    
   end if; 
  
   -- Clear live revision
Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v
diff -u -r1.19 -r1.20
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	14 Jun 2001 00:23:21 -0000	1.19
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	23 Aug 2001 02:26:21 -0000	1.20
@@ -274,7 +274,7 @@
     a.attribute_name = drop_attribute__attribute_name;
     
   if NOT FOUND then
-    raise EXCEPTION ''-20000: Attribute %:% does not exist in content_type.drop_attribute'', content_type, attribute_name;
+    raise EXCEPTION ''-20000: Attribute %:% does not exist in content_type.drop_attribute'', drop_attribute__content_type, drop_attribute__attribute_name;
   end;
 
   -- Drop the attribute