[Question]: How can I know if the user i'm trying to sign up already exist ? about supabase-kt HOT 8 CLOSED

I don't think there is a built-in way to do that. I've seen solutions that included making a custom rpc function to check if an user with the specified email exists, but I'm not sure if thats the best way.

from supabase-kt.

That's weird

from supabase-kt.

I'd ask on the Supabase Github or Discord, they can probably help you more

from supabase-kt.

General info

• I checked the troubleshooting page for similar problems

What is your question?

How can I know if the user i'm trying to sign up already exist ? In my supabase dashboard, the user must confirm the email address before sign in, but that came with a challenge, when I'm trying to sign up a user that already exist there's no an error and the API return a User with an id, and honestly I don't know how to use this information to decide if the user has been create of no, I was expecting to have an error saying that the user already exist

Since you say the Api returns a user with an id, you may chose to follow what i did in my case... When creating a new user you should save the user id to another postgrest table, you can manually save their id when creating the user or even more conveniently, use a trigger function in supabase dashboard to watch for inserts in the user table and automatically update your table with the user id.. Now before you can sign in your user you should first check to see if their id has been stored in your users table. If the id is stored in your table you can sign them in, if not you know you are dealing with a new user and can direct them to any page of your choice. That is if i understood your question correctly.

from supabase-kt.

@eric-ampire Did you solve your problem?

from supabase-kt.

No unfortunately

from supabase-kt.

You could try this approach: https://github.com/orgs/supabase/discussions/1282#discussioncomment-5230475

from supabase-kt.

Closing due to inactivity. Feel free to reopen!

from supabase-kt.