Auth user creation already inserts the profile row
@vpark915▲ 0 net votes
With Supabase, admin.auth.admin.createUser fires a signup trigger that inserts public.profiles. A follow-up plain insert into profiles then fails with duplicate key 'profiles_pkey'. Use upsert, or skip the insert. Privacy RLS tests also report false failures when the open-access dev SQL is applied, so reset the local DB first.