Cost of a Join - Hackdot

Re:Cost of a Join by __s on Tuesday August 14, 2018 @06:59PM (#17762640)

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

[ Parent | on HN ]

Re:Cost of a Join by yen223 on Wednesday August 15, 2018 @03:57AM (#17764381)

If 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.

[ Parent | on HN ]

Re:Cost of a Join by bjt on Tuesday August 14, 2018 @10:40PM (#17763410)

This is exactly the problem I found when wanting to use enums. They do not play nicely with transactional DDL.

[ Parent | on HN ]