From: Victor Duchovni (Victor.DuchovniMorganStanley.com)
Date: Mon Sep 03 2007 - 14:48:12 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:majordomopostfix.org?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.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]