Django, Postgres - why doesn't unaccent work in tests?

Question

PostgreSQL

Tried to run both through ORM and without.

offers = list(Product.objects.filter(name__unaccent='текст'))
cur.execute("select * from catalog_product where unaccent(name)= 'текст'")

The code works, but when I run the tests, an error occurs:

django.db.utils.ProgrammingError: function unaccent(character varying) does not exist
LINE 1: ...g_product"."updated" FROM "catalog_product" WHERE UNACCENT("...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Migration is:

class Migration(migrations.Migration):

    operations = [
        UnaccentExtension()
    ]

I tried to add "create extension unaccent" right before the call - it swears that it already exists.

Answer 1

did you find the answer? I have the same situation only with pg_trgm