Cannot create new users — auth.users.id default missing and cannot be altered
Hi everyone — I’m having an issue where new user signups fail with “Database error creating new user.”
After checking, I found that auth.users.id has no default value.
I tried:
ALTER TABLE auth.users ALTER COLUMN id SET DEFAULT gen_random_uuid();
but got ERROR: must be owner of table users.
pgcrypto is installed and gen_random_uuid() works fine — it’s just that I don’t have ownership of the auth.users table (owned by supabase_auth_admin).
After checking, I found that auth.users.id has no default value.
I tried:
ALTER TABLE auth.users ALTER COLUMN id SET DEFAULT gen_random_uuid();
but got ERROR: must be owner of table users.
pgcrypto is installed and gen_random_uuid() works fine — it’s just that I don’t have ownership of the auth.users table (owned by supabase_auth_admin).
