Problem with trigger on auth.users
Dear all, I am total beginner, just using various AIs to assist in buildingvmy platform. Now I ran into an issue and got stuck. I kindly ask for your support. This issue is that my trigger on auth.users does not fire when a new user is created via Supabase Auth. The function is correct, the trigger is attached, the foreign key is deferrable, RLS is not blocking, and no errors or notices appear in the logs. No row is created in profiles. Furthemore, I have tried all standard troubleshooting steps, including adding RAISE NOTICE to the function, and still see no evidence that the trigger is firing. (Sidenote: The AI framed the summary :o)!).
