Index: openacs-4/packages/survey/sql/postgresql/survey-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/postgresql/survey-drop.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/survey/sql/postgresql/survey-drop.sql	30 Nov 2002 17:49:43 -0000	1.3
+++ openacs-4/packages/survey/sql/postgresql/survey-drop.sql	20 Sep 2008 11:45:01 -0000	1.4
@@ -10,8 +10,12 @@
 select drop_package('survey_section');
 select drop_package('survey');
 
-drop view survey_responses_latest;
-drop view survey_ques_responses_latest;
+-- The following two views are already dropped by the drop_package
+-- commands by using used for "drop function .... CASCADE';
+
+--drop view survey_responses_latest;
+--drop view survey_ques_responses_latest;
+
 drop table survey_question_responses;
 drop table survey_responses;
 drop table survey_question_choices;
@@ -64,4 +68,4 @@
 -- gilbertw - logical_negation is defined in utilities-create.sql in acs-kernel
 -- drop function logical_negation(boolean);
 
-
+\i survey-notifications-drop.sql
Index: openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/survey/sql/postgresql/survey-notifications-drop.sql	20 Sep 2008 11:45:01 -0000	1.1
@@ -0,0 +1,50 @@
+-- Survey
+--
+-- @author dave@thedesignexperience.org, ben@openforce.biz
+-- @creation-date 2002-08-03
+--
+-- integration with Notifications
+create function inline_0 ()
+returns integer as '
+
+declare
+        impl_id integer;
+        v_foo   integer;
+begin
+
+
+      v_foo := acs_sc_impl_alias__delete (
+		    ''NotificationType'',
+                    ''survey_response_notif_type'',
+                    ''GetURL''
+                 );
+
+      v_foo := acs_sc_impl_alias__delete (
+                    ''NotificationType'',
+                    ''survey_response_notif_type'',
+                    ''ProcessReply''
+                 );
+
+      v_foo := acs_sc_binding__delete (
+                    ''NotificationType'',
+                    ''survey_response_notif_type''
+                 );
+
+       SELECT type_id from notification_types where short_name = ''survey_response_notif''
+       INTO v_foo;
+
+       v_foo := notification_type__delete(v_foo);
+
+       v_foo := acs_sc_impl__delete (
+                     ''NotificationType'',
+                     ''survey_response_notif_type''
+                  );
+
+return 0;
+end;' language 'plpgsql';
+
+select inline_0();
+
+drop function inline_0();
+
+