id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 20271 Filtering over generic relations with TextField/CharField object_id gives PostgreSQL error: No operator matches the given name and argument type(s). You might need to add explicit type casts. arctelix@… nobody "It seems this error is still around! {{{ Traceback (most recent call last): File ""/app/.heroku/src/django-tastypie/tastypie/resources.py"", line 202, in wrapper response = callback(request, *args, **kwargs) File ""/app/.heroku/src/django-tastypie/tastypie/resources.py"", line 441, in dispatch_list return self.dispatch('list', request, **kwargs) File ""/app/.heroku/src/django-tastypie/tastypie/resources.py"", line 473, in dispatch response = method(request, **kwargs) File ""/app/.heroku/src/django-tastypie/tastypie/resources.py"", line 1244, in get_list to_be_serialized = paginator.page() File ""/app/.heroku/src/django-tastypie/tastypie/paginator.py"", line 186, in page count = self.get_count() File ""/app/.heroku/src/django-tastypie/tastypie/paginator.py"", line 118, in get_count return self.objects.count() File ""/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py"", line 351, in count return self.query.get_count(using=self.db) File ""/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/query.py"", line 418, in get_count number = obj.get_aggregation(using=using)[None] File ""/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/query.py"", line 384, in get_aggregation result = query.get_compiler(using).execute_sql(SINGLE) File ""/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py"", line 818, in execute_sql cursor.execute(sql, params) File ""/app/.heroku/python/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py"", line 52, in execute return self.cursor.execute(query, args) DatabaseError: operator does not exist: integer = text LINE 1: ... INNER JOIN ""django_comments"" ON (""pins_pin"".""id"" = ""django_... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. }}}" Bug closed Database layer (models, ORM) dev Normal duplicate postgresql, pk shanto@… Accepted 0 0 0 0 0 0