#10015: contrib.comments inline on Postgres 8.3 fails to cast integer to text
---------------------------------------------------+------------------------
Reporter: carljm | Owner: carljm
Status: reopened | Milestone:
Component: Database layer (models, ORM) | Version: 1.0
Resolution: | Keywords:
postgresql, pk
Stage: Accepted | Has_patch: 1
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
---------------------------------------------------+------------------------
Changes (by ramusus):
* status: closed => reopened
* resolution: fixed =>
Comment:
I just get similar error while try to delete object with comments as
GenericRelationField:
{{{
class List(models.Model):
....
comments = generic.GenericRelation(Comment,
object_id_field='object_pk')
}}}
Traceback or error:
{{{
Traceback:
File
"/home/ram/workspace/movister/web_site/django/core/handlers/base.py" in
get_response
96. response = middleware_method(request,
callback, callback_args, callback_kwargs)
File "/home/ram/workspace/movister/web_site/firepython/middleware.py"
in process_view
369. return self._profile_wrap(callback)(*args,
**callback_kwargs)
File
"/home/ram/workspace/movister/web_site/django/contrib/admin/options.py" in
wrapper
243. return self.admin_site.admin_view(view)(*args,
**kwargs)
File
"/home/ram/workspace/movister/web_site/django/utils/decorators.py" in
__call__
36. return self.decorator(self.func)(*args, **kwargs)
File
"/home/ram/workspace/movister/web_site/django/utils/decorators.py" in
_wrapped_view
86. response = view_func(request, *args,
**kwargs)
File
"/home/ram/workspace/movister/web_site/django/utils/decorators.py" in
__call__
36. return self.decorator(self.func)(*args, **kwargs)
File
"/home/ram/workspace/movister/web_site/django/views/decorators/cache.py"
in _wrapped_view_func
70. response = view_func(request, *args, **kwargs)
File
"/home/ram/workspace/movister/web_site/django/contrib/admin/sites.py" in
inner
190. return view(request, *args, **kwargs)
File
"/home/ram/workspace/movister/web_site/django/utils/decorators.py" in
_wrapped_view
86. response = view_func(request, *args,
**kwargs)
File
"/home/ram/workspace/movister/web_site/django/contrib/admin/options.py" in
delete_view
1123. obj.delete()
File "/home/ram/workspace/movister/web_site/django/db/models/base.py"
in delete
604. delete_objects(seen_objs, using)
File "/home/ram/workspace/movister/web_site/django/db/models/query.py"
in delete_objects
1192. del_query.delete_batch_related(pk_list,
using=using)
File
"/home/ram/workspace/movister/web_site/django/db/models/sql/subqueries.py"
in delete_batch_related
65. self.do_query(f.m2m_db_table(), where,
using=using)
File
"/home/ram/workspace/movister/web_site/django/db/models/sql/subqueries.py"
in do_query
27. self.get_compiler(using).execute_sql(None)
File
"/home/ram/workspace/movister/web_site/django/db/models/sql/compiler.py"
in execute_sql
674. cursor.execute(sql, params)
File
"/home/ram/workspace/movister/web_site/debug_toolbar/panels/sql.py" in
execute
90. return self.cursor.execute(sql, params)
Exception Type: ProgrammingError at /admin/movister/list/1/delete/
Exception Value: operator does not exist: text = integer
LINE 1: DELETE FROM "django_comments" WHERE ("object_pk" IN (1) AND
...
^
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.
}}}
I use development trunk version r12267 of Django
--
Ticket URL: <http://code.djangoproject.com/ticket/10015#comment:13>
Django <http://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 post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
