Re: [Exim] PostgreSQL & Aliassing Again

Top Page
Delete this message
Reply to this message
Author: Philip Hazel
Date:  
To: Sander Smeenk
CC: exim-users
Subject: Re: [Exim] PostgreSQL & Aliassing Again
On Wed, 28 Aug 2002, Sander Smeenk wrote:

> But I also want that all email to a $local_part NOT SPECIFIED in the
> database goes to 'thisuser@???'.



   data = ${lookup pgsql{SELECT destination FROM exim_user_aliases
   WHERE lower(localpart) = lower('${quote_pgsql:$local_part}') AND
   lower(owner) = lower('${quote_pgsql:$domain}') LIMIT 1}}
                                                         ^
                                                         ^
Make use of the "lookup failed" features of Exim. Instead of ending your
expansion with "}}" use


}{$value}{thisuser@???}}

Voila.

--
Philip Hazel            University of Cambridge Computing Service,
ph10@???      Cambridge, England. Phone: +44 1223 334714.