Index: openacs-4/packages/notifications/tcl/notification-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/notification-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/notifications/tcl/notification-procs-postgresql.xql	1 Aug 2002 12:56:16 -0000	1.2
+++ openacs-4/packages/notifications/tcl/notification-procs-postgresql.xql	20 Sep 2002 21:19:00 -0000	1.3
@@ -14,8 +14,9 @@
             insert
             into notification_user_map
             (notification_id, user_id, sent_date)
-            values
-            (:notification_id, :user_id, now())
+            select :notification_id, :user_id, now()
+            from dual where exists (select 1 from notifications
+                                    where notification_id = :notification_id)
         </querytext>
     </fullquery>