From 8ed25d65ea7546fafd808086fa07e7e5bb5428fc Mon Sep 17 00:00:00 2001 From: Petter Friberg Date: Thu, 20 Apr 2023 15:19:44 +0200 Subject: Fixed #34505 -- Skipped varchar_pattern_ops/text_pattern_ops index creation when db_collation is set in related field. --- django/db/backends/postgresql/schema.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'django') diff --git a/django/db/backends/postgresql/schema.py b/django/db/backends/postgresql/schema.py index 19f8b225e2..18899a6a2b 100644 --- a/django/db/backends/postgresql/schema.py +++ b/django/db/backends/postgresql/schema.py @@ -100,7 +100,9 @@ class DatabaseSchemaEditor(BaseDatabaseSchemaEditor): return None # Non-deterministic collations on Postgresql don't support indexes # for operator classes varchar_pattern_ops/text_pattern_ops. - if getattr(field, "db_collation", None): + if getattr(field, "db_collation", None) or ( + field.is_relation and getattr(field.target_field, "db_collation", None) + ): return None if db_type.startswith("varchar"): return self._create_index_sql( -- cgit v1.2.1