'Test creation of PostgreSQL-specific text indexes (#12234)'

@skipUnless((connections[DEFAULT_DB_ALIAS].vendor == 'postgresql'), 'This    is    a    postgresql-specific    issue')
def test_postgresql_text_indexes(self):

    from .models import IndexedArticle
    connection = connections[DEFAULT_DB_ALIAS]
    index_sql = connection.creation.sql_indexes_for_model(IndexedArticle, no_style())
    self.assertEqual(len(index_sql), 5)
    self.assertIn('("headline"    varchar_pattern_ops)', index_sql[1])
    self.assertIn('("body"    text_pattern_ops)', index_sql[3])
    self.assertIn('("slug"    varchar_pattern_ops)', index_sql[4])
