Re: [Django] #35539: SearchVector GinIndex raises IMMUTABLE error (was: contrib/postgres/search.py COALESCE breaks GIN Index creation on PostgreSQL 15)

[Django]

#35539: SearchVector GinIndex raises IMMUTABLE error
----------------------------------+------------------------------------
Reporter: Alastair D'Silva | Owner: (none)
Type: Bug | Status: new
Component: contrib.postgres | Version: 5.0
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------+------------------------------------
Changes (by Sarah Boyce):

* cc: Mariusz Felisiak, Simon Charette (added)
* stage: Unreviewed => Accepted
* summary:
contrib/postgres/search.py COALESCE breaks GIN Index creation on
PostgreSQL 15
=> SearchVector GinIndex raises IMMUTABLE error

Comment:

Thank you for the report, was able to replicate the error 👍
I believe this is a valid bug, I've never used these before myself but
looks like it's being used
[https://docs.djangoproject.com/en/5.0/ref/contrib/postgres/search/#performance
as documented]

Here is my "rough" test if it gives anyone a starting point

{{{#!diff
--- a/tests/postgres_tests/test_indexes.py
+++ b/tests/postgres_tests/test_indexes.py
@@ -379,6 +379,19 @@ class SchemaTests(PostgreSQLTestCase):
editor.remove_index(Scene, index)
self.assertNotIn(index_name,
self.get_constraints(Scene._meta.db_table))

+ def test_search_vector_gin_index(self):
+ index_name = "search_vector_gin"
+ index = GinIndex(SearchVector("field"), name=index_name)
+ with connection.schema_editor() as editor:
+ editor.add_index(TextFieldModel, index)
+ table = TextFieldModel._meta.db_table
+ constraints = self.get_constraints(table)
+ self.assertIn(index_name, constraints)
+ self.assertIn(constraints[index_name]["type"], GinIndex.suffix)
+ with connection.schema_editor() as editor:
+ editor.remove_index(TextFieldModel, index)
+ self.assertNotIn(index_name, self.get_constraints(table))
+
def test_cast_search_vector_gin_index(self):
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35539#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.