Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hi! I have a dashboard where the admin should be able to delete a user when he wants to. I tried to use trigger functions to do that,  but it doesn't look like it's working.

Eveytime I delete a row in my public.profile table, it should triggers a function like that:

begin
DELETE FROM auth.user
WHERE id = new.id;

return new;
end

But it doesn't work!

How can I do it? I use SvelteKit on Vercel with Supabase as my DB and storage

You are going to need to use the deleteUser method since the `auth` schema doesn't belong to the user you are trying to do the delete with  https://supabase.com/docs/reference/javascript/auth-api-deleteuser

The user that was used to create that function might not have permission to delete columns from that table

Something that looks wrong in your function above is you are using `new.id` but since it would have been deleted you probably need to use `old.id`