Fixed #33607 -- Made PostgresIndex.create_sql() respect the "using" argument.

1 files changed, 16 insertions, 0 deletions

diff --git a/tests/postgres_tests/test_indexes.py b/tests/postgres_tests/test_indexes.py
index 2f74203e8b..9da2f33ae8 100644
--- a/tests/postgres_tests/test_indexes.py
+++ b/tests/postgres_tests/test_indexes.py
@@ -8,6 +8,7 @@ from django.contrib.postgres.indexes import (
     GistIndex,
     HashIndex,
     OpClass,
+    PostgresIndex,
     SpGistIndex,
 )
 from django.db import NotSupportedError, connection
@@ -646,6 +647,21 @@ class SchemaTests(PostgreSQLTestCase):
                     editor.add_index(Scene, index)
         self.assertNotIn(index_name, self.get_constraints(Scene._meta.db_table))
 
+    def test_custom_suffix(self):
+        class CustomSuffixIndex(PostgresIndex):
+            suffix = "sfx"
+
+            def create_sql(self, model, schema_editor, using="gin", **kwargs):
+                return super().create_sql(model, schema_editor, using=using, **kwargs)
+
+        index = CustomSuffixIndex(fields=["field"], name="custom_suffix_idx")
+        self.assertEqual(index.suffix, "sfx")
+        with connection.schema_editor() as editor:
+            self.assertIn(
+                " USING gin ",
+                str(index.create_sql(CharFieldModel, editor)),
+            )
+
     def test_op_class(self):
         index_name = "test_op_class"
         index = Index(