Trying to update a public user table when email is updated on auth. The trigger is on auth (AFTER UPDATE), and the function looks like below. However, it doesn't work, and actually bugs me from signing in if it's turned on. (getting this error on log in when the trigger is on: "Database error granting user")
begin update table set email = new.email where id = new.id; return new;end;
begin update table set email = new.email where id = new.id; return new;end;
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.