[sam] [PATCH] Fix for amavisd-sql constraint problem

[Josh Endries]

Hello,

I'm not a PHP/PEAR/Horde expert, but attached is a patch I hacked up
to fix a constraint problem I was having with SAM. The problem is
that, when a user submits a whitelist, the existence of sender
addresses is only checked for addresses in the existing wblist and
not for new additions. If one user adds an address, and someone else
tries to add that same address, it breaks the unique index in the DB.
This patch simply checks for the existence of new addresses. If
found, it uses the current ID, otherwise it inserts as usual.

Josh
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: sam-diff
Url: http://lists.horde.org/archives/sam/attachments/20050814/f9d8dbf4/sam-diff.ksh
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 254 bytes
Desc: OpenPGP digital signature
Url : http://lists.horde.org/archives/sam/attachments/20050814/f9d8dbf4/signature.bin