Is there support for using Postgres ENUM with Ash.Type.Enum? I do know that you can do that if you create the migration yourself like it is done in this commit: chore: test enum types · ash-project/ash_postgres@a6577d5 · GitHub But, the question is more if there is now support for it in the migrat…

Postgres Enums can be annoying to maintain if you ever need to change a value etc. if it was me I would use a text column and something similar to Ecto.Enum, not sure if Ash has that, but I imagine it would.

It has, but that became an issue if you have a huge table with a bunch of enums since that will increase the size of the table a lot. At the same time I don’t want to use integers since it decreases readability when querying the DB directly. AFAIK, that annoying part was more prevalent before Postg…

True, worst of all is mostly in a distributed application, as the db is central, if you have a few applications running then you got a race condition, especially if you rarely have any low usage periods. But again YMMV, and I have no idea what constraints you’re working with.

[image] Schultzer: Postgres Enums can be annoying to maintain if you ever need to change a value etc Can you elaborate? Is there something wrong with ALTER TYPE?

No there is not something inherently wrong with it, although it does imposes constraints that can be completely avoided by having the logic live in the application, that way you can run two different version of your application without any downtime or performance degradation. As software is rarely s…

Postgres ENUM support for Ash.Type.Enum?

Questions & Help Questions

garrison January 3, 2026, 3:17pm 5

Can you elaborate? Is there something wrong with ALTER TYPE?