Index: openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql,v diff -u -N -r1.10 -r1.11 --- openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 2 Sep 2008 22:32:00 -0000 1.10 +++ openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 27 Mar 2010 14:26:47 -0000 1.11 @@ -36,6 +36,10 @@ and creation_date <= notif_date and (notif_date is null or notif_date < current_timestamp) and interval_id = :interval_id + and exists (select 1 from acs_object_party_privilege_map ppm + where ppm.object_id = notification_requests.object_id + and ppm.privilege = 'read' + and ppm.party_id = notification_requests.user_id) order by user_id, type_id, notif_date