The doctor was wrong. It's a lot more painful to give birth than have a kidney stone. Of course, you might be a man and that wouldn't apply.

It's also been known for decades that rectal NSAIDs are as good as narcotics for the treatment of renal colic, unless there are contraindications to using them.