Index: openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql,v
diff -u -r1.16.2.4 -r1.16.2.5
--- openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	6 Feb 2003 16:47:51 -0000	1.16.2.4
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-create.sql	27 Feb 2003 13:45:29 -0000	1.16.2.5
@@ -379,8 +379,8 @@
   attributes     clob
 );
 
-comment on column cr_revision_attributes.attributes is '
-  An XML document representing the compiled attributes for a revision
+comment on table cr_revision_attributes is '
+  Table contains an XML document representing the compiled attributes for a revision.
 ';
 
 create global temporary table cr_content_text (
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v
diff -u -r1.10 -r1.10.2.1
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	25 May 2002 14:30:02 -0000	1.10
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	27 Feb 2003 13:45:29 -0000	1.10.2.1
@@ -396,7 +396,6 @@
         return 'f';
 end is_publishable;
 
-
 function is_valid_child (
   item_id		in cr_items.item_id%TYPE,
   content_type		in acs_object_types.object_type%TYPE
@@ -412,7 +411,7 @@
   -- first check if content_type is a registered child_type
   begin
     select
-      max_n into v_max_children
+      sum(max_n) into v_max_children
     from
       cr_type_children
     where
Index: openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	11 May 2001 04:43:39 -0000	1.2
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-type.sql	27 Feb 2003 13:45:29 -0000	1.2.4.1
@@ -645,7 +645,8 @@
   select decode(count(*),0,0,1) into v_exists 
     from cr_type_children
     where parent_type = register_child_type.parent_type
-    and child_type = register_child_type.child_type;
+    and child_type = register_child_type.child_type
+    and relation_tag = register_child_type.relation_tag;
 
   if v_exists = 0 then
 
@@ -914,5 +915,3 @@
 
 end;
 /
-
-
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.39.2.1 -r1.39.2.2
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	21 Jan 2003 13:45:03 -0000	1.39.2.1
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	27 Feb 2003 13:44:55 -0000	1.39.2.2
@@ -721,7 +721,7 @@
 
   -- first check if content_type is a registered child_type
   select
-    max_n into v_max_children
+    sum(max_n) into v_max_children
   from
     cr_type_children
   where
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.24 -r1.24.2.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	19 Sep 2002 02:02:08 -0000	1.24
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	27 Feb 2003 13:44:55 -0000	1.24.2.1
@@ -701,7 +701,8 @@
   select count(*) into v_exists 
     from cr_type_children
     where parent_type = register_child_type__parent_type
-    and child_type = register_child_type__child_type;
+    and child_type = register_child_type__child_type
+    and relation_tag = register_child_type__relation_tag;
 
   if v_exists = 0 then