Unexpected error in database trigger

begin
  insert into public.profiles (id, email, invite_id)
  values (new.id, new.email, (new.raw_user_meta_data ->> 'invite_id')::uuid);
  return new;
end;

begin
  update public.invites set receiver_id = new.id
  where id = (new.raw_user_meta_data ->> 'invite_id')::uuid;

  insert into public.profiles (id, email)
  values (new.id, new.email);
  return new;
end;