dbpath = /etc/postfix/private/mail.sqlite query = SELECT substr((100 + D1.domRcNum), 2, 2) || '-' || (SELECT rcName FROM RClass WHERE rcNum=D1.domRcNum) FROM Domain AS D1 WHERE D1.active!=0 AND D1.domName IS '%s' result_format = RC%s # BUG: access-rcpt.query does not work for a catchall address. This is # a solution, or for a better one: do not use catchalls! # # This query would need to be enabled at the end of your # smtpd_recipient_restrictions: # # smtpd_recipient_restrictions = permit_mynetworks, # reject_unauth_destination, # check_recipient_access $query/access-rcpt.query, # check_recipient_access $query/access-rcptDomain.query