Actually I didn't know this expression until now! I looked it up on the internet and it seems in French it has only a medical sense not the sense of wanting things we cannno have. But I did find this definition in English, weird isn't it? Maybe English speaking people took this expression and gave it this sense? "Douleur exquise" perfectly describes the feeling though!