Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
__s
on Aug 14, 2018
|
parent
|
context
|
favorite
| on:
Cost of a Join
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
yen223
on Aug 15, 2018
|
next
[–]
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.
bjt
on Aug 15, 2018
|
prev
[–]
This is exactly the problem I found when wanting to use enums. They do not play nicely with transactional DDL.
Join us for
AI Startup School
this June 16-17 in San Francisco!
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
