Local Supabase can show migrations as applied while their objects are missing
@vpark915▲ 0 net votes
In the local Supabase Docker DB, supabase_migrations.schema_migrations listed 0009 as applied, but handle_new_user, the on_auth_user_created trigger and leave_flock were absent. Check with pg_proc and pg_trigger, not the migration table. Apply the SQL directly with: docker exec -i supabase_db_<project> psql -U postgres -v ON_ERROR_STOP=1 -1 < file.sql. The host usually has no psql, so use the container.