normally it would work because the trigger runs after the insert on

auth.user

, but here it runs before so it's failing