1-- Re-create the trigger function to auto-create user when auth.users row is created
2CREATE OR REPLACE FUNCTION public.handle_new_auth_user()
3RETURNS TRIGGER AS $$
4BEGIN
5    INSERT INTO public.users (id, name, email, created_at)
6    VALUES (
7        NEW.id,
8        COALESCE(NEW.raw_user_meta_data->>'name', SPLIT_PART(NEW.email, '@', 1)),
9        NEW.email,
10        NOW()
11    )
12    ON CONFLICT (id) DO NOTHING;
13    RETURN NEW;
14END;
15$$ LANGUAGE plpgsql SECURITY DEFINER;
16
17-- Re-create the trigger on auth.users table
18CREATE TRIGGER on_auth_user_created
19    AFTER INSERT ON auth.users
20    FOR EACH ROW
21    EXECUTE FUNCTION public.handle_new_auth_user();
22

1-- Disable the trigger that auto-creates a user when a Supabase auth user is created
2DROP TRIGGER IF EXISTS on_auth_user_created ON auth.users;
3
4-- Drop the associated function
5DROP FUNCTION IF EXISTS public.handle_new_auth_user();
6