{{{#!python
index = Index(
name=indexname,
fields=['-body'],
opclasses=['text_pattern_ops'],
)
}}}
{{{
django.db.utils.ProgrammingError: syntax error at or near
"text_pattern_ops"
LINE 1: ...rdered" ON "indexes_indexedarticle2" ("body" DESC text_patte...
}}}
This is because `opclass` is supposed to be inserted before `ASC | DESC`
in `CREATE INDEX`.
See https://www.postgresql.org/docs/current/sql-createindex.html
--
Ticket URL: <https://code.djangoproject.com/ticket/30903>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
* has_patch: 0 => 1
Comment:
PR: https://github.com/django/django/pull/11966
--
Ticket URL: <https://code.djangoproject.com/ticket/30903#comment:1>
* severity: Normal => Release blocker
* stage: Unreviewed => Accepted
--
Ticket URL: <https://code.djangoproject.com/ticket/30903#comment:2>
* status: assigned => closed
* resolution: => fixed
Comment:
In [changeset:"fa5f3291e7f2611d53e64ab481ebe951b0161791" fa5f3291]:
{{{
#!CommitTicketReference repository=""
revision="fa5f3291e7f2611d53e64ab481ebe951b0161791"
Fixed #30903 -- Fixed migrations crash on PostgreSQL when adding Index
with opclasses and ordering.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30903#comment:3>
Comment (by Mariusz Felisiak <felisiak.mariusz@…>):
In [changeset:"318d186d7ed443d4c09745c755d4d186f9ed86d5" 318d186d]:
{{{
#!CommitTicketReference repository=""
revision="318d186d7ed443d4c09745c755d4d186f9ed86d5"
[3.0.x] Fixed #30903 -- Fixed migrations crash on PostgreSQL when adding
Index with opclasses and ordering.
Backport of fa5f3291e7f2611d53e64ab481ebe951b0161791 from master
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30903#comment:4>
Comment (by Mariusz Felisiak <felisiak.mariusz@…>):
In [changeset:"7fe09e6d41b35d5a9a03783650249723313d3793" 7fe09e6d]:
{{{
#!CommitTicketReference repository=""
revision="7fe09e6d41b35d5a9a03783650249723313d3793"
[2.2.x] Fixed #30903 -- Fixed migrations crash on PostgreSQL when adding
Index with opclasses and ordering.
Backport of fa5f3291e7f2611d53e64ab481ebe951b0161791 from master
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30903#comment:5>