Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql	19 Aug 2002 20:37:15 -0000	1.1
+++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-0.1d-0.2d.sql	19 Aug 2002 20:38:49 -0000	1.2
@@ -1 +1,13 @@
-\i ../notifications-package-create.sql
+drop function notification__delete;
+
+create function notification__delete(integer)
+returns integer as '
+declare
+    p_notification_id               alias for $1;
+begin
+    delete from notifications where notification_id = p_notification_id;
+    perform acs_object__delete(p_notification_id);
+    return 0;
+end;
+' language 'plpgsql';
+