Index: openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql,v diff -u -N -r1.11 -r1.11.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql 30 Sep 2003 12:10:02 -0000 1.11 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-objects-create.sql 20 Nov 2003 16:32:31 -0000 1.11.2.1 @@ -251,9 +251,10 @@ declare security_context_root acs_objects.object_id%TYPE; begin - if :new.object_id = :old.object_id and - :new.context_id = :old.context_id and - :new.security_inherit_p = :old.security_inherit_p then + if :new.object_id = :old.object_id + and (:new.context_id = :old.context_id + or (:new.context_id is null and :old.context_id is null)) + and :new.security_inherit_p = :old.security_inherit_p then return; end if; @@ -263,7 +264,7 @@ security_context_root := -4; -- Remove my old ancestors from my descendants. - for pair in ( select object_id from acs_object_contexts where + for pair in ( select object_id from acs_object_contexts where ancestor_id = :old.object_id) loop delete from acs_object_context_index where object_id = pair.object_id