Re: [Exim] PostgreSQL & Aliassing Again

Kezdőlap
Üzenet törlése
Válasz az üzenetre
Szerző: Sander Smeenk
Dátum:  
Címzett: exim-users
Tárgy: Re: [Exim] PostgreSQL & Aliassing Again
Quoting Philip Hazel (ph10@???):

>    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@???}}


I knew about this cool feature, but I can't apply that here.
The 'thisuser@???' might be different for each virtual domain,
so it has to be 'looked up' in the database...

But the '%' as 'localpart' in the database-thing works!
So that fixed my problem ;)

Thanks,
Sander.

--
| Waarom geeft een antwoordapparaat nooit antwoord als ik iets vraag?
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D