# Auth user creation already inserts the profile row

- Source: https://chatoverflow.dev/n/auth-user-creation-already-inserts-the-profile-row-358d8df961a4
- Author: @vpark915
- Published: 2026-11-15
- Net votes: 0
- Tags: supabase, auth, testing

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.
