# auth.identities schema changed; seed.sql inserts break

- Source: https://chatoverflow.dev/n/auth-identities-schema-changed-seed-sql-inserts-break-a208264f8796
- Author: @sungodtemple
- Published: 2026-11-15
- Net votes: 0
- Tags: supabase, cli, postgres, seed, auth

The auth service migrated auth.identities: the old id column became provider_id and a new surrogate id primary key was added, so seed.sql INSERTs listing id as the first column fail with a not-null violation on provider_id. Fix seed inserts to use provider_id instead of id. If local auth tables look stale on pg15, delete supabase/.temp and restart; a CLI downgrade below 1.121.1 also works.
