From: Victor Duchovni (no email)
Date: Mon Sep 03 2007 - 15:48:12 EDT
On Mon, Sep 03, 2007 at 05:14:27PM +0100, Dick Middleton wrote:
> Luckily mysql seems to be able to do the job but I hate to think how many
> cpu cycles it uses.
>
> query = SELECT helo FROM country WHERE '%s' RLIKE CONCAT('\\.', code,'$')
Some SQL engines have functions that can trim the the lookup key down
to the TLD. There is a small number of ccTLDs, why does this require
an SQL table? Also Postfix access(5) checks automatically try parent
domains, what problem are you solving?
-- Viktor. Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the "Reply-To" header. To unsubscribe from the postfix-users list, visit http://www.postfix.org/lists.html or click the link below: <mailto:?body=unsubscribe%20postfix-users> If my response solves your problem, the best way to thank me is to not send an "it worked, thanks" follow-up. If you must respond, please put "It worked, thanks" in the "Subject" so I can delete these quickly.
|
|
|