我正在使用Django 2.0和postgresql 9.6
我已经在我的应用程序(文章)中创建并清空了迁移文件,其中包含以下内容,以添加uncent和trigram扩展名
# Generated by Django 2.0 on 2018-02-06 22:34
from django.db import migrations
from django.contrib.postgres.operations import UnaccentExtension, TrigramExtension
class Migration(migrations.Migration):
dependencies = [
('articles', '0012_auto_20180205_2234'),
]
operations = [
UnaccentExtension(),
TrigramExtension()
]
然后,我尝试运行以下查询:
from django.contrib.postgres.search import SearchQuery, SearchRank, SearchVector
vector = SearchVector('title',config='unaccent', weight='A') + SearchVector('description',config='unaccent', weight='B')
query = SearchQuery('india')
Article.objects.annotate(rank=SearchRank(vector, query)).filter(rank__gte=0.3).order_by('rank')
ProgrammingError: text search configuration "unaccent" does not exist
LINE 1: ...rticle"."qa_bool", ts_rank((setweight(to_tsvector('unaccent'...