X-Git-Url: https://git.madduck.net/etc/mailfilter.git/blobdiff_plain/a3ee3c50317dcb2aa2b0041ee8c050d35220ff8b..4f7fed650f35de2eada637d565f5e7d1c611d8c5:/procmail/record-delayed-mail

diff --git a/procmail/record-delayed-mail b/procmail/record-delayed-mail
index e83391b..72ff6b8 100644
--- a/procmail/record-delayed-mail
+++ b/procmail/record-delayed-mail
@@ -8,9 +8,10 @@ DO_QUERY="$SQLITE $DELAYED_QUEUE_DB"
 DATA="$MSGID"
 INCLUDERC=$PMDIR/sql-escape
 
-QUERY="insert into messages values
-  ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS)"
-TRAP="$TRAP; $DO_QUERY '$QUERY'"
+QUERY="insert into messages values ($DATA, '\\'\$DESTFILE\\'', $RELEASE_TS);
+       select * from messages where msgid = $DATA"
+TRAP="$TRAP; case \"$($DO_QUERY '$QUERY')\" in '') 
+      echo 'delay:       failed to insert reference into database';; esac"
 
 QUERY
 DATA