Is Massage supposed to be painful?

Sore muscles which contain trigger points, will be painful when pressed upon. However there are many different types of pain, but confusingly only one word to describe all these sensations. The pain from a trigger point being pressed slowly is a pain with which the...