totersapp / asana-integration-test

0 stars 0 forks source link

Remove unncessary constraint from migration files #11

Open abbood opened 5 years ago

abbood commented 5 years ago

business value add

make it easier to run migrations on older postgresql versions (ie for staging)

analysis

running migration on amaozn rds with postgres version 9.6.3 results in this error

SQLSTATE[42704]: Undefined object: 7 ERROR: constraint "users_type_check" of relation "users" does not exist (SQL: ALTER TABLE users DROP CONSTRAINT users_type_check;)

to get around it, we must take out those checks