UUIDField in Django (error:operator does not exist: integer = uuid)

Question

i want to use uuid field as my id (primary key) but there is something wrong with it and i can't fix it ...

this is my model

class Course(models.Model):

    id = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)
    title = models.CharField(max_length=90)
    description = models.TextField()
    author = models.CharField(max_length=60)
    image = models.ImageField(upload_to='courses/images')
    intro_video = models.FileField(upload_to='courses/videos')
    free = models.BooleanField(default=False)
    price = models.CharField(max_length=60, blank=True)
    completed = models.BooleanField(default=False)
    duration = models.CharField(max_length=30, blank=True)
    created_at = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.title

when i try to add a new course it gave's me this error

ProgrammingError at /admin/courses/course/add/
operator does not exist: integer = uuid
LINE 1: ..., "created_at" = NULL WHERE "courses_course"."id" = 'a130811...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.

Exception Type: ProgrammingError
Exception Value: operator does not exist: integer = uuid

my database is postgresql

please help me.

can you paste the code in which you are creating a new Course? — Horatiu Jeflea
– Horatiu Jeflea, Commented Feb 13, 2020 at 11:11
i dont know if i understand you right, but use django admin to add a new course @Horatiu Jeflea — Ehsan
– Ehsan, Commented Feb 13, 2020 at 11:35
got it now. But if you try to create a new Course from code, does it work? Either Course.objects.create or course.save() — Horatiu Jeflea
– Horatiu Jeflea, Commented Feb 13, 2020 at 11:37

Pedro Rozo · Accepted Answer · 2021-02-24 04:23:38Z

1

Use :

id=models.CharField(primary_key=True,default=uuid.uuid4, editable=False, max_length=36)

answered Feb 24, 2021 at 4:23

Pedro Rozo

258 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mikesiwi · Accepted Answer · 2021-09-24 13:36:39Z

1

I find another "simpliest" solution for this issue if you wanna use uuid field as "ID" you need to start with this field as id befroe the first migration the cast missing part is because you id field dont make the change the propper way to an uuidField

answered Sep 24, 2021 at 13:36

Mikesiwi

191 bronze badge

Collectives™ on Stack Overflow

UUIDField in Django (error:operator does not exist: integer = uuid)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related