#35311: Addindex operation generates wrong sql code for Postgresql GinIndex
-------------------------------------+-------------------------------------
Reporter: Pierre | Owner: nobody
Juhen |
Type: Bug | Status: new
Component: Database | Version: 5.0
layer (models, ORM) | Keywords: postgresql
Severity: Normal | migration
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Hi,
I created a Gin Index using :
''GinIndex(OpClass(Lower('title'), name='gin_trgm_ops'),
name="name_gin_trgm_title_affaire"),''
makemigrations generates the following code :
''migrations.AddIndex(
'' model_name='affaire',
index=django.contrib.postgres.indexes.GinIndex(django.contrib.postgres.indexes.OpClass(django.db.models.functions.text.Lower('title'),
name='gin_trgm_ops'), name='name_gin_trgm_title_affaire'),''
),''
SQLMIGRATE generates a wrong code :
''CREATE INDEX "name_gin_trgm_title_affaire" ON "affaires_affaire" USING
gin ((LOWER("title")));''
Instead of (too many parenthesis) :
''CREATE INDEX "name_gin_trgm_title_affaire" ON "affaires_affaire" USING
gin (LOWER("title"));''
There is a manual workaround, but its annoying.
Thank you.
Regards
--
Ticket URL: <https://code.djangoproject.com/ticket/35311>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018e46648af5-3399de75-a558-4441-9da1-e8cf9d6707e8-000000%40eu-central-1.amazonses.com.
