django.db.utils.ProgrammingError: data type character varying has no default operator class for access method "gin"

Question

I am working on a django project, where I want to create gin indexing on my model's attribute. I want to create gin indexing on

 SchoolName = models.CharField(max_length=200, blank=False, null=False)

But, I am getting this error

 django.db.utils.ProgrammingError: data type character varying has no default operator class for access method "gin"

Help me to figure out this error

Can you put the traceback also the code where you use "gin" method? — Juanmi Gabarron
– Juanmi Gabarron, Commented Apr 19, 2018 at 14:00
i can not share the codes. But i can give you details. Actually i want to create indexing on charfield of my school model in djnago so that i can perform trigram search on the schoolname. — Sweta
– Sweta, Commented Apr 20, 2018 at 5:04
class Meta: indexes = [GinIndex(fields=['Field_Name'])] this is how i am creating gin index on schoolname attribute of school model. — Sweta
– Sweta, Commented Apr 20, 2018 at 5:05
@Sweta Looks like the SchoolName field does not have a built-in operator class in Postgres See built-in operator classes here: postgresql.org/docs/current/static/gin-builtin-opclasses.html Also see Django documentation on how to handle this by installing a btree_gin_extension here: docs.djangoproject.com/en/2.0/ref/contrib/postgres/indexes/… This will allow support for char, varchar e.t.c — rtindru
– rtindru, Commented Apr 20, 2018 at 7:17

rtindru · Accepted Answer · 2018-04-20 07:24:41Z

11

Create a migrations file to install the BtreeGinExtension to enable GIN Indexes to be built on varchar data types.

from django.contrib.postgres.operations import BtreeGinExtension

class Migration(migrations.Migration):
    ...

    operations = [
        BtreeGinExtension(),
        ...
    ]

References:

answered Apr 20, 2018 at 7:24

rtindru

5,3779 gold badges43 silver badges64 bronze badges

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

3 Comments

ashes999 Over a year ago

Hi, which migrations file should I add this too if I already have data and an existing schema?

Felix Farquharson Over a year ago

where does the migrations file go? what is the rest of the code?

Saurabh Saxena Over a year ago

This need to be added in the migrations files that gets generated after ./manage.py makemigrations command

Collectives™ on Stack Overflow

django.db.utils.ProgrammingError: data type character varying has no default operator class for access method "gin"

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related