© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
4 replies
dies.irae65

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;
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

On auth trigger only if email confirmed
SupabaseSSupabase / help-and-questions
4y ago
Trigger on email verification
SupabaseSSupabase / help-and-questions
4y ago
Auth.trigger
SupabaseSSupabase / help-and-questions
6mo ago
Can't get auth trigger working
SupabaseSSupabase / help-and-questions
5mo ago