Error adding GinIndex to model in Django with Postgres

Question

I am trying to add GinIndex to my model however, I am getting an error when migrating:

django.db.utils.ProgrammingError: data type character varying has no default operator class for access method "gin"
HINT:  You must specify an operator class for the index or define a default operator class for the data type.

This is my model:

class Post(models.Model):
    title = models.CharField(max_length=100)
    guid_url = models.CharField(max_length=255,unique=True, null=True)
    content = models.TextField(validators=[MaxLengthValidator(1200)])
    author = models.ForeignKey(Profile, on_delete=models.CASCADE)
    date_posted = models.DateTimeField(auto_now_add=True)
    last_edited= models.DateTimeField(auto_now=True)
    tags = TaggableManager(help_text="Tags", blank=True)
    likes= models.ManyToManyField(Profile, blank=True, related_name='post_likes')
    
    class Meta:
        indexes = [
            GinIndex(fields=['title','content'],name='search_idx_post')
        ]

I was wondering what is causing this issue I cannot find how to resolve this issue.

Thanks in advance!

Why do you want this index? That is, what operations are you hoping to accelerate? — jjanes
– jjanes, Commented Jun 28, 2020 at 13:51
Then you need to build the index on the tsvector, not on the raw text field itself. See somethig like docs.djangoproject.com/en/3.0/ref/contrib/postgres/search — jjanes
– jjanes, Commented Jun 28, 2020 at 14:04
This question is similar to: django.db.utils.ProgrammingError: data type character varying has no default operator class for access method "gin". If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — l0lander
– l0lander, Commented Jul 27, 2024 at 1:36

Oscar Chen · Accepted Answer · 2021-07-12 19:43:35Z

4

Inside the migration file created by Django for adding the GinIndex, add the following:

from django.contrib.postgres.operations import BtreeGinExtension

and then add this to the inside of the operations list, ie:

operations = [
    BtreeGinExtension()
    ...
]

Run this migration again and it should go through.

answered Jul 12, 2021 at 19:43

Oscar Chen

6466 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Error adding GinIndex to model in Django with Postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related