Auth trigger didn't run locally
I have a very simple trigger to create a row in a
I then followed the instructions here to pull my database schema from the hosted environment and run Supabase locally. Everything from the hosted database schema came across to the locally running environment as expected (including the function/trigger mentioned above, which I can see in the locally running Supabase console).
However, when I pointed my app at the locally running Supabase environment and created an account, an auth user got created but a row in the
How would I go about beginning to debug this?
profiles table after insert on auth.users, almost exactly the same as the example here. It works as expected in the hosted Supabase environment.I then followed the instructions here to pull my database schema from the hosted environment and run Supabase locally. Everything from the hosted database schema came across to the locally running environment as expected (including the function/trigger mentioned above, which I can see in the locally running Supabase console).
However, when I pointed my app at the locally running Supabase environment and created an account, an auth user got created but a row in the
profiles table did not get created (like it does in the hosted Supabase environment), i.e. the trigger appeared to not get executed in the local environment.How would I go about beginning to debug this?
