Delete Trigger not working
'''-- Users Delete Function
create or replace function public.handle_delete_user() returns trigger as $$ begin
delete from public.users
where id = new.id;
return new;
end;
$$ language plpgsql security definer;
-- END Users Delete Function
--
-- Users Delete Trigger
create trigger on_auth_user_deleted
after
delete on auth.users for each row execute procedure public.handle_delete_user();
-- END Users Update Trigger'''