[exim-dev] [Bug 932] deprecated escaping in pgsql lookup

Top Page
Delete this message
Reply to this message
Author: Jakob Hirsch
Date:  
To: exim-dev
Subject: [exim-dev] [Bug 932] deprecated escaping in pgsql lookup
------- You are receiving this mail because: -------
You are on the CC list for the bug.

http://bugs.exim.org/show_bug.cgi?id=932

Jakob Hirsch <jh.exim-bugzilla@???> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |INVALID





--- Comment #4 from Jakob Hirsch <jh.exim-bugzilla@???> 2009-12-15 09:19:30 ---
(In reply to comment #2)

> When local_part contains underscore pgsql lookup creates sql query like this:
> SELECT id FROM exim_users WHERE login=lower('test\_test') AND
> domena=lower('kolekcja.mejor.pl')


> I think query should looks like this:
> SELECT id FROM exim_users WHERE login=lower(E'test\_test') AND
> domena=lower(E'kolekcja.mejor.pl')


You found the solution yourself. Just change the query in your exim config so
that it fits your local DBMS installation. There's not much Exim can do about
that. First, the expansion code isn't there to check your SQL syntax. Second,
it's currently not possible (AFAIK) for an expansion function to change
anything _outside_ its scope, i.e. ${quote_pgsql:...} will be replaced by some
string, but besides that it can not change the string it's embedded in. And I
don't think it would be a good idea to change that.

If you feel this needs some discussion, please take it to exim-dev, bugzilla is
really bad for that.


--
Configure bugmail: http://bugs.exim.org/userprefs.cgi?tab=email