Sorry you have to learn the hard way
...We all, had been there...done that.
I do have to disagree with the first posters...
Any medication error can be portentially fatal (that is nursing 101). This is not about other nurses being "perfect"... it is about the safety of your patient. This is what the Joint commission makes such a huge emphasis on safe medication administration.
Be grateful that your patient was not harmed in any way and consider what happened a learning experience. I am not sure what is your hospital policy in regard to momentarily increasing your sedation/analgesic drips, just to keep a patient sedated, while "turning." But as you had discovered, that is a dangerous practice...one I am assuming you are doing without a physician's order. In the future, if discomfort is an issue, obtaing an order (you worked hard for your license!!) to bolus/IVP pain medication/sedation and if using a drip, have another nurse double check with you.