Dental work during pregnancy

I have to get a cavity filled, and I'm definitely not looking forward to it!! I would wait until after the baby is born if I could, but my tooth is in pain and it can't wait :( 
Any other women had to have dental work during their pregnancies? How did it go?