Index: openacs-4/packages/survey/sql/postgresql/survey-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/postgresql/survey-create.sql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/survey/sql/postgresql/survey-create.sql	30 Nov 2002 17:49:43 -0000	1.6
+++ openacs-4/packages/survey/sql/postgresql/survey-create.sql	23 Feb 2003 18:23:26 -0000	1.7
@@ -32,9 +32,6 @@
 
 
 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;
 
         select acs_privilege__add_child('survey_admin_survey','survey_create_survey');
         select acs_privilege__add_child('survey_admin_survey','survey_modify_survey');
@@ -44,14 +41,6 @@
         select acs_privilege__add_child('survey_admin_survey','survey_delete_question');
 
         select acs_privilege__add_child('read','survey_take_survey');
-
-        -- 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 ();
-
         select acs_privilege__add_child('admin','survey_admin_survey');
 
 end;
