Safely Casting Columns in Postgresql Without Losing Data

You know that moment when your “quick prototype” becomes a production system and suddenly your Postgres schema is working against you? Early in one of my projects, we used PostgreSQL enums to keep things clean and tightly constrained. It made sense: ...