Index: openacs-4/packages/dotlrn/sql/postgresql/security-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/security-create.sql,v
diff -u -r1.3.2.2 -r1.3.2.3
--- openacs-4/packages/dotlrn/sql/postgresql/security-create.sql	22 Oct 2002 20:41:59 -0000	1.3.2.2
+++ openacs-4/packages/dotlrn/sql/postgresql/security-create.sql	4 Mar 2003 19:51:08 -0000	1.3.2.3
@@ -58,11 +58,6 @@
         -- the ability to spam a community
         perform acs_privilege__create_privilege(''dotlrn_spam_community'');
 
-        -- temporarily drop this trigger to avoid a data-change violation 
-        -- on acs_privilege_hierarchy_index while updating the child privileges.
-
-        drop trigger acs_priv_hier_ins_del_tr on acs_privilege_hierarchy;
-
         -- Consistent permissions
         perform acs_privilege__add_child(''dotlrn_edit_community'', ''dotlrn_view_community'');
         perform acs_privilege__add_child(''dotlrn_admin_community'', ''dotlrn_edit_community'');
@@ -79,14 +74,9 @@
         -- for now, we only want admins to be able to browse by default
         perform acs_privilege__add_child(''admin'', ''dotlrn_browse'');
 
-        -- re-enable the trigger before the last insert to force the 
-        -- acs_privilege_hierarchy_index table to be updated.
-        create trigger acs_priv_hier_ins_del_tr after insert or delete
-        on acs_privilege_hierarchy for each row
-        execute procedure acs_priv_hier_ins_del_tr ();
-
         -- no default permissions
         return 0;
+
 end;' language 'plpgsql';
 
 select inline0();