Respect unique keys in materialized views

[ckoppelman]

Postgres supports unique indexes on materialized views. It would be fantastic if django-db-views migrations would create indexes for unique=True and unique_together like standard Django models.

[BezBartek]

Hello,
Yes, I know about it and I have plan to support it.
I also think of more complicated indexes, my idea is to support all what you can provide to indexes: https://docs.djangoproject.com/en/5.0/ref/models/indexes/
for materialized views.

[ckoppelman]

Terrific. Any advice to patch it in the mean time? I guess I could just RunSQL every time I update my view

[BezBartek]

Ye, you need to write your own migration with Run SQL.
you can put that operation in the same migration that creates view.