Hello, How to automatically save new user to the d...
# help
l
Hello, How to automatically save new user to the database? I followed this guide - https://daily-dev-tips.com/posts/supabase-automatically-create-user-profiles-on-sign-up/ It's not working, just getting 500 errors. Need help. Also, triggers and functions are not available for production, what is the alternative?
n
Hello @Lukas V! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
g
Easy question first, triggers and functions (postgres) are part of Postgres and are fully production. The warning in the Studio UI is about the function and trigger editors.
n
itemas (2022-03-17)
g
I assume by "automatically save new user to database" you mean make a copy of their information to a public table like in the example. The auth.user table is automatically set up for new users. A 500 error likely means something is going wrong in your trigger function. You might be able to get debug info from the database log under settings, otherwise post your function code here, with the name and relevant fields in your profile table you are inserting into.