On Fri, 2008-01-18 at 12:30 +0100, Jarek Zgoda wrote: > I just stumbled upon strange behavior of django-0.96.1 and > postgresql-8.2 combo. Essentially, different versions of postgresql-8.2 > client libraries (or server, I am not a PostgreSQL expert) used with > Django-0.96.1 ORM produce different results for lookups that use ILIKE > (eg. iexact, icontains). When the lookup value contain underscore > character, Django-0.96.1 ORM escapes underscore character in ILIKE > queries with double backslashes. This is accepted by some versions of > postgresql-8.2 with warning (but expected result is returned), and some > versions just do not return anything. > > Is this fact known? Can anybody help me debug this issue and find the > culprit component that I have to fix/switch to another version?
I don't have time right now to look at this in depth (and I'm currently quite behind in my django-users reading, but I saw this fly past), but I suspect you might have to set standard_conforming_strings to false in PostgreSQL 8.2. See http://www.postgresql.org/docs/8.2/static/runtime-config-compatible.html Basically, PostgreSQL is trying to be more standards compliant by default, at the cost of slightly impacting backwards compatibility. You might also want to look at escape_string_warning (setting it to false, since the warnings will get annoying after a while). Long-term, we can fix this in Django (to send more SQL-standard strings), but it's a little fiddly, because we try to be fairly version neutral and obviously not everybody's running 8.2. Regards, Malcolm -- The hardness of butter is directly proportional to the softness of the bread. http://www.pointy-stick.com/blog/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
