Once a use signs up there is no need to redirect to the sign-in page

[imor]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

After a user signs up they are redirected to the sign-in page, but this is not needed as the user is already logged in. So, the user should be either redirected to the home page or whichever page they were on before the sign-up page.

To Reproduce

Steps to reproduce the behavior, please provide code snippets or a repository:

1. Go to the sign-up page and sign up as a new user.
2. Once you finish signing up you will be taken to the log-in page.
3. Go to the home page and click the user avatar next to the search bar at the top.
4. Notice that it shows you are logged in.

Expected behavior

The user can be taken directly to the home page after they sign-up.

Screenshots

N/A

System information

N/A

Additional context

N/A