I hope you are talking about cold pasta, like pasta salad. I think hot mayonnaise would be a kind of icky. I have never actually made pasta with mayonnaise, but I do like a good macaroni salad from the deli.
Pasta with mayo? That doesn't sound very good to me at all, but then again, different strokes for diferent folks. I probably like certain tings that may not sound good to you either. Who knows? It takes all kinds to make a world.