4 ms·
I was using enums, but then I found out that you can't alter an enum inside a transaction.. very painful in a knex environment where up/down all occurs within a
by __s 8y ago
I was using enums, but then I found out that you can't alter an enum inside a transaction.. very painful in a knex environment where up/down all occurs within a transaction
- nimchimpsky 8y agoEh? What do you mean. You can most certainly update a row with a new value in the enum column.
- bjt 8y agoThis is exactly the problem I found when wanting to use enums. They do not play nicely with transactional DDL.
- yen223 8y agoIf knex doesn't provide facilities for running migrations outside of a transaction, you're going to have an awful time. Useful operations like CREATE INDEX CONCURRENTLY can't be run in transactions.