Index: openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql	12 Jun 2002 15:24:02 -0000	1.2
+++ openacs-4/packages/forums/sql/postgresql/forums-forums-drop.sql	23 Feb 2003 18:20:31 -0000	1.3
@@ -13,10 +13,6 @@
 create function inline_0 ()
 returns integer as '
 begin
-    -- 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;
-
     -- remove children
     perform acs_privilege__remove_child(''read'',''forum_read'');
     perform acs_privilege__remove_child(''create'',''forum_create'');
@@ -27,11 +23,6 @@
     perform acs_privilege__remove_child(''forum_moderate'',''forum_post'');
     perform acs_privilege__remove_child(''forum_write'',''forum_read'');
 
-    -- reenable for trigger update
-    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 ();
-
     perform acs_privilege__remove_child(''forum_write'',''forum_post'');
     
     perform acs_privilege__drop_privilege(''forum_moderate'');