Index: openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	28 Aug 2003 09:41:58 -0000	1.11
+++ openacs-4/packages/notifications/sql/postgresql/notifications-core-create.sql	11 Dec 2003 21:40:09 -0000	1.12
@@ -166,7 +166,8 @@
     -- this is to allow responses to notifications
     response_id                     integer
                                     constraint notif_reponse_id_fk
-                                    references acs_objects (object_id),
+                                    references acs_objects (object_id)
+                                    on delete cascade,
     -- this is the user that caused the notification to go out
     notif_user                      integer
                                     constraint notif_user_id_fk