trigger on sign-up
I have created a function to insert data when user sign up. currently I am testing it only on supabase dashboard only, It is working fine whenever I try to insert user in auth user table with sql query, but when I try to creating a user getting error : Failed to create user. Database error creating new user.
'CREATE OR REPLACE FUNCTION handle_new_user()
RETURNS TRIGGER AS $$
BEGIN
INSERT INTO public.users (user_id, user_name, email)
VALUES (NEW.id, 'hammadzahid', 'hammadzahid@ccript.com');
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER after_user_signup
AFTER INSERT ON auth.users
FOR EACH ROW
EXECUTE FUNCTION handle_new_user();
DROP TRIGGER IF EXISTS after_user_signup ON auth.users;
INSERT INTO auth.users (id, email)
VALUES ('123e4567-e89b-12d3-a456-426614174000', 'test@example.com');'
'CREATE OR REPLACE FUNCTION handle_new_user()
RETURNS TRIGGER AS $$
BEGIN
INSERT INTO public.users (user_id, user_name, email)
VALUES (NEW.id, 'hammadzahid', 'hammadzahid@ccript.com');
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER after_user_signup
AFTER INSERT ON auth.users
FOR EACH ROW
EXECUTE FUNCTION handle_new_user();
DROP TRIGGER IF EXISTS after_user_signup ON auth.users;
INSERT INTO auth.users (id, email)
VALUES ('123e4567-e89b-12d3-a456-426614174000', 'test@example.com');'
