Hello all, I'm having trouble running knex migrations against the supabase DB. While my script runs great in the supabase SQL editor, it fails to run in knex when removing a trigger from the auth.users table. The same script creates that trigger fine, but cannot delete it. Is this a known limitation?

Yeah you will need to elevate the postgres user to a super user first before you can do this, do a search on the Supabase GitHub discussions and you will see I’ve asked about this and the answer is there on how to elevate the postgres user. Sorry can’t link to it at the moment as I’m using my mobile to reply.