creating user profiles with signups
Hi,
I've been trying to automatically create a user profile along with a specific role for each user created that I get from a different roles table but somehow when I try to do so I am blocked completely after the first two users. It is a foreign key with the roles table and is an int8. I get an error 500 and then this message duplicate key value violates unique constraint "profiles_pkey". I am new to Supabase so I am a bit stuck understanding how to go about this issue. If I can get some help with that it would be great.
I've been trying to automatically create a user profile along with a specific role for each user created that I get from a different roles table but somehow when I try to do so I am blocked completely after the first two users. It is a foreign key with the roles table and is an int8. I get an error 500 and then this message duplicate key value violates unique constraint "profiles_pkey". I am new to Supabase so I am a bit stuck understanding how to go about this issue. If I can get some help with that it would be great.
