Trigger not being created in local DB

After creating the initial migration file and running my first local instance of my supabase DB, I noticed that upon signing up, the profiles table isn't being automatically filled. In my main DB hosted on supabase, a new row is immediately added upon sign up.

After further research I found that the following trigger is missing in my local db, it comes from the User Management Starter.

create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

The trigger exists in my supabase hosted DB, however my migrated local instance does not contain it. I also do not see the trigger in the migration file.

Any idea why I it didn't automatically add it to the migration file?

I also attempted running

supabase db diff --use-migra --linked

supabase db diff --use-migra --linked

This was unsuccessful as it did not find any differences. Thank you in advance.

Supabase•4y ago•

14 replies

juanvilladev

Trigger not being created in local DB

create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

supabase db diff --use-migra --linked

supabase db diff --use-migra --linked

This was unsuccessful as it did not find any differences. Thank you in advance.

Trigger not being created in local DB

Similar Threads

Trigger not being created in local DB

Similar Threads

Similar Threads

Similar Threads