Altering PostgreSQL columns from one enum to another
Altering the type of a column in postgres from one enum type to another requires an intermediate cast to text. Additionally, if there is a default value for the field, it cannot be altered and instead must be dropped and re-added as the new type. Simple case: New type contains all old-type values In the simple … [Read more…]