diff options
author | Adolfo Fitoria <adolfo.fitoria@gmail.com> | 2012-09-21 18:03:37 -0600 |
---|---|---|
committer | Adolfo Fitoria <adolfo.fitoria@gmail.com> | 2012-09-21 18:03:37 -0600 |
commit | 47a4bc923966046e6d3e76d4dcf0bfd55f2c4f66 (patch) | |
tree | 5d90d64fc654f5d0ae20cbcef0722d31ff5d2b28 | |
parent | f982936c5510d064ed11cc4d89048c33c9470bc5 (diff) | |
download | askbot-47a4bc923966046e6d3e76d4dcf0bfd55f2c4f66.tar.gz askbot-47a4bc923966046e6d3e76d4dcf0bfd55f2c4f66.tar.bz2 askbot-47a4bc923966046e6d3e76d4dcf0bfd55f2c4f66.zip |
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/
-rw-r--r-- | askbot/context.py | 8 |
1 files changed, 7 insertions, 1 deletions
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}), |