Either way is fine, but it would be fairly simple to create an upgrade.sql script that contains the appropriate drop and create trigger statements to change the triggers from before to after triggers. You could then just do: psql -f upgrade.sql and you would be up and running without having to reload any data.
