What role does cyclooxygenase play in pain and inflammation?

There are two types of Cox, theres Cox-1 and Cox-2. Cox-1 is an enzyme that helps regulate stomach acid and keep it in the stomach. While Cox-2 promotes inflammationin the body, now this is neccesarily a bad thing. Unless There becomes a high amount of Cox-2.