jesseplusplus, 24 days ago

@veganstraightedge if fx doesn’t offer a function to do that for you, I would write the migration in raw SQL. Postgres has a DROP TRIGGER IF EXISTS: https://www.postgresql.org/docs/current/sql-droptrigger.html

jamie, 24 days ago

@jesseplusplus @veganstraightedge Was just coming to say this. I don’t see a lot of (or any?) functionality in ActiveRecord for dealing with triggers or SQL functions. The raw SQL with the IF EXISTS clause seems to be the best route.

veganstraightedge, 24 days ago

@jamie @jesseplusplus thanks, both of yall!

honestly, I’m surprised that the fx gem doesn’t have this (that I know of) as an argument on drop_function and drop_trigger

jesseplusplus, 23 days ago

@veganstraightedge @jamie I’m surprised too. I would honestly expect the drop trigger function to use the IF EXISTS as the default for safety. Maybe you can submit a PR 🙂