CREATE OR REPLACE FUNCTION handle_new_user()
RETURNS TRIGGER AS $$
BEGIN
  INSERT INTO utilisateurs (id, email, statut, roles)
  VALUES (
    NEW.id,
    NEW.email,
    'actif'::statut_utilisateur_enum,
    ARRAY['client'::role_enum]
  );
  RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER SET search_path = public;