Index: openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	9 Aug 2002 20:51:50 -0000	1.6
+++ openacs-4/packages/notifications/sql/postgresql/notifications-package-create.sql	12 Aug 2002 19:56:32 -0000	1.7
@@ -204,9 +204,9 @@
     p_object_id                     alias for $1;
     v_request                       RECORD;
 begin
-    for v_request in (select request_id
-                      from notification_requests
-                      where object_id= p_object_id)
+    for v_request in select request_id
+                     from notification_requests
+                     where object_id= p_object_id
     loop
         perform notification_request__delete(v_request.request_id);
     end loop;