There's a "bug" in postgreSQL (in fact, it's more a feature: strong typed, contrary to

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Ah that's indeed how it should be implemented. This is one for <a href="https://github

Filtering not working with postgreSQL: " No operator matches the given name and argument type(s). You might need to add explicit type casts." about django-fluent-comments HOT 5 OPEN

gustavklopp commented on June 19, 2024

Filtering not working with postgreSQL: " No operator matches the given name and argument type(s). You might need to add explicit type casts."

from django-fluent-comments.

Comments (5)

vdboor commented on June 19, 2024 2

Thanks! I see now what's happening. This is because Django's "GenericForeignKey" uses a Text field for the ID field. In postgres, this breaks with fields that store the data in a UUIDField.

This is clearly an issue for https://github.com/django/django-contrib-comments, as they've implemented the base model that we build upon.

from django-fluent-comments.

vdboor commented on June 19, 2024

I'm cleaning up old issues, I'm presuming this is already fixed.

This looks like an Django issue.

from django-fluent-comments.

bashu commented on June 19, 2024

I'm cleaning up old issues, I'm presuming this is already fixed.

@vdboor no, it's not! Here an example:

import uuid

class ArticlesTable(models.Model):
    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)

    comments_set = CommentsRelation()

and running this query:

 ArticlesTable.objects.filter(comments_set__isnull=False)

gives me:

UndefinedFunction                         Traceback (most recent call last)
/usr/local/lib/python3.6/site-packages/django/db/backends/utils.py in _execute(self, sql, params, *ignored_wrapper_args)
     84             else:
---> 85                 return self.cursor.execute(sql, params)
     86

UndefinedFunction: operator does not exist: uuid = text
LINE 1: ... JOIN "django_comments" ON ("recipes_recipe"."id" = "django_...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

from django-fluent-comments.

bashu commented on June 19, 2024

@vdboor as a hint: https://alexgaynor.net/2010/may/04/cool-new-django-taggit-api/

from django-fluent-comments.

vdboor commented on June 19, 2024

Ah that's indeed how it should be implemented. This is one for https://github.com/django/django-contrib-comments though, as we mainly provide nice Ajax UI fluff on top of it!

from django-fluent-comments.

Recommend Projects