Index: openacs.org-dev/packages/notifications/tcl/sweep-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/notifications/tcl/sweep-procs-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs.org-dev/packages/notifications/tcl/sweep-procs-postgresql.xql 29 Nov 2004 05:05:21 -0000 1.4 +++ openacs.org-dev/packages/notifications/tcl/sweep-procs-postgresql.xql 29 Nov 2004 06:21:11 -0000 1.5 @@ -12,7 +12,7 @@ from notifications inner join notification_requests using (type_id, object_id) inner join acs_objects on (notification_requests.request_id = acs_objects.object_id) left outer join notification_user_map using (notification_id, user_id) - where sent_date is null and creation_date <= notif_date + where sent_date is null and creation_date <= notif_date and notif_date > now() - 30