Re: [Exim] Exim & PostgreSQL 2 :)

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Joachim Wieland
Ημερομηνία:  
Προς: exim-users
Αντικείμενο: Re: [Exim] Exim & PostgreSQL 2 :)
Hi,

On Fri, Mar 08, 2002 at 04:51:47PM -0000, Andy Hedges wrote:
> Oh and then use the variable like this


> local_domains =     machine.example.com : \
>             localhost : \
>             pgsql;PGSQL_LOCAL_MAILALIAS


Yes, the last line is the important Information:

local_domains is a list, not a string, so the proper syntax (without
macros) is:

domainlist local_domains = pgsql;select domain from tbldomains \
where domain = '$domain' and ... ;

Is it really necessary to add a "DISTINCT" ?

Other question: When should one use the quote function? Of course it is
necessary to do it as often as possible, could there arise SQL injection
attacks with malformed e-Mail headers? (Assuming that the MUA doesn't
reject them because of invalid characters)... It seems to be used quite
seldom in the examples posted here.


Joachim

--
*****PGP key available - send e-mail request***** - ICQ: 37225940
When space has no frontiers, then why the hell does the Voyager crew always
meet the same species?