externalid has a unique constraint which probably plays into this behavior