Hi Mark, as per docs the 1st match (row) that it is returned from sql wins. I'll be guessing, when lookup is made with %k, more than one row is returned but only 1st one is actually fetched. Would it be possible to combine those rows ascending to the priority e.g 0 is highest priority 7 lowest, to get the final ruleset.
Now you are probably wondering why. You could set the defaults and then override them in deeper levels. NULL value would mean leave value as is, every other would simply override the previous one. Having inheritance you could set up a general rule for whole domain and override some settings with per-email rules. There would be no need to copy the values from domain rule to the e-mail rule when such rule is created by user. End users can usually change just some parts of the policy (quar level, spam subject and spam points). I'm guessing here but, the number of policies that match is probably a lot smaller than 8. Well even if all 8 are returned combining them should be extremely fast. -- No system, however painstakingly designed, can withstand the destructive force of an idiot who's found the power switch. - Z lepimi pozdravi / Kind regards, Miha Vrhovnik ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org
