Database error saving new user

[silentworks]

You generally get this error when trying to invite a new user from the dashboard or when trying to insert a user into a table using the table editor in the Supabase dashboard.

This error is normally associated with a side effect of a database transaction.

Common causes of this error:

• You have a trigger/trigger function setup on the auth.users table
• You have added a constraint on the auth.users table which isn't being met
• You are using Prisma and it has broken all the permissions on the auth.users table

Debugging this error:

• You can use the Auth logs explorer to find the issue with more information
• You can use the Postgres logs explorer

Kapture.2023-03-16.at.12.49.26.mp4

[GaryAustin1]

See also https://github.com/orgs/supabase/discussions/21247