> On Sep 19, 2017, at 8:39 PM, Andreas Thienemann <andr...@bawue.net> wrote: > > That would work. A bit of a hack though and I think it would only work for > virtual aliases with one level of redirection but not for something like > i...@example.com -> i...@example.net -> spam-mails.
Some SQL implementations support recursive CTEs, or you can periodically construct a table that holds the recursive closure of such aliases. Do be careful though to only apply the rule to 1-to-1 aliases, and not 1 to many groups, just in case a group contains a member that maps to such an address (that's likely a misconfiguration, but could happen). In some schemas groups that expand to multiple addresses are stored differently than users that might have an email redirect. -- Viktor.