Index: openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql,v
diff -u -N -r1.8 -r1.9
--- openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql	2 Dec 2006 12:49:54 -0000	1.8
+++ openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-postgresql.xql	17 Dec 2006 17:04:10 -0000	1.9
@@ -6,7 +6,7 @@
    <fullquery name="acs_mail_lite::check_bounces.send_notification_to_bouncing_email">
      <querytext>
 
-       insert into acs_mail_lite_bounce_notif (user_id, notification_count, notification_time)
+       insert into acs_mail_lite_bounce_notif (party_id, notification_count, notification_time)
        select party_id, 0 as notification_count,
            date_trunc('day', current_timestamp - to_interval(1 + :notification_interval, 'days'))
            as notification_time
@@ -21,7 +21,7 @@
 
        select u.user_id, u.email, u.first_names || ' ' || u.last_name as name
        from cc_users u, acs_mail_lite_bounce_notif n
-       where u.user_id = n.user_id
+       where u.user_id = n.party_id
        and u.email_bouncing_p = 't'
        and n.notification_time < current_timestamp - to_interval(:notification_interval, 'days')
        and n.notification_count < :max_notification_count
@@ -35,7 +35,7 @@
        update acs_mail_lite_bounce_notif
        set notification_time = date_trunc('day',current_timestamp),
            notification_count = notification_count + 1
-       where user_id = :user_id
+       where party_id = :user_id
 
      </querytext>
    </fullquery>