#20271: PostgreSQL error: No operator matches the given name and argument
type(s).
You might need to add explicit type casts.
-------------------------------------+-------------------------------------
Reporter: arctelix@… | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgresql, pk | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by timgraham:
Old description:
> 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.
New description:
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.
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/20271#comment:9>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/076.806f079da2aae1a9a6d60757c16ac0f4%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
