You are viewing a plain text version of this content. The canonical link for it is here.

Posted to docs@httpd.apache.org by bu...@apache.org on 2018/03/25 09:17:53 UTC

[Bug 60440] RewriteMap map name fails if not all lowercase with PostgreSQL DBD map

https://bz.apache.org/bugzilla/show_bug.cgi?id=60440

Christophe JAILLET <ch...@wanadoo.fr> changed:

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

--- Comment #3 from Christophe JAILLET <ch...@wanadoo.fr> ---
Hi,

apparently, this is the way PostgreSQL works. It turns identifier in lowercase,
if not double-quoted.

See: 
https://www.postgresql.org/docs/9.4/static/sql-syntax-lexical.html (§4.1.1)
and
https://stackoverflow.com/questions/20878932/are-postgresql-column-names-case-sensitive

So in your case, if the myMap has been created with double-quotes, you must
have the double-quotes somewhere.

I guess that:
RewriteMap mymap "dbd:SELECT \"%s\""
or something similar would work for you.

I don't see anything wrong with Apache itself here, so closing as INVALID.
Updating the doc makes also little sense to me, as it is the way PostgreSQL
works. We can not handle in our doc all the subtleties of other software.


If you can try the alternative syntax, please share your results here.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: docs-unsubscribe@httpd.apache.org
For additional commands, e-mail: docs-help@httpd.apache.org