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.3 -r1.4 --- openacs.org-dev/packages/notifications/tcl/sweep-procs-postgresql.xql 4 Jul 2003 21:00:34 -0000 1.3 +++ openacs.org-dev/packages/notifications/tcl/sweep-procs-postgresql.xql 29 Nov 2004 05:05:21 -0000 1.4 @@ -26,8 +26,7 @@ type_id, delivery_method_id, response_id, - notif_date, - notif_user + notif_date 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)