Trigger on auth update email not working

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;

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;

Trigger on auth update email not working

Similar Threads

Similar Threads

Similar Threads