Handle new users in your frontend/backend after signup instead of using a trigger:

const { data, error } = await supabase
  .from('users')
  .insert([{ user_id: user.id, email: user.email, role: 'Low' }]);

This avoids breaking the signup flow and is safer for production.