From 47a4bc923966046e6d3e76d4dcf0bfd55f2c4f66 Mon Sep 17 00:00:00 2001 From: Adolfo Fitoria Date: Fri, 21 Sep 2012 18:03:37 -0600 Subject: Fix for postgressql bug in order_by clauses when postgres have no correct locale setting: more info: http://scottbarnham.com/blog/2007/11/20/case-insensitive-ordering-with-django-and-postgresql/ --- askbot/context.py | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/askbot/context.py b/askbot/context.py index 48c1cf3b..812805e6 100644 --- a/askbot/context.py +++ b/askbot/context.py @@ -68,7 +68,13 @@ def application_settings(request): global_group = models.tag.get_global_group() - groups = models.Group.objects.exclude_personal().exclude(id=global_group.id).order_by('name') + + if 'postgresql_psycopg2' in askbot.get_database_engine_name(): + groups = models.Group.objects.exclude_personal().exclude(id=global_group.id).extra( + select={'lower_name': 'lower(name)'}).order_by('name') + else: + groups = models.Group.objects.exclude_personal().exclude(id=global_group.id).order_by('name') + groups = groups.values('id', 'name') group_list = [{'link': _get_group_url({'name': global_group.name, 'id': global_group.id}), -- cgit v1.2.3-1-g7c22