This is actually an interesting problem for a lot of people!
In general, those of us with dry skin can remain very slippy when we start poling, or even when we're warm, and by the time we start sweating, it's never any better. It's very frustrating!
However, the flip side to that is the moisturizer itself- your lotion may appear sticky when you apply it, and it may seem that way for quite a while on your skin, too. However, if you apply too close to the time that you pole, sometimes even the same day, you may be leaving residue on the pole, and you may also have slippy problems, because most moisturizers will do that.
The best advice is this- drink lots of water to make sure your skin is getting the kind of nurturing it needs, and apply any kind of moisturizers after pole dance, or on your off-days.
After 40 minutes of pole dancing, it's natural to sweat quite a bit, and to get a little slippery. Taking a bit of time to towel off, clean the pole, and drink some water may be all you need to get back to it. Also, fans. I love fans for this, because sweat is meant to be evaporated by the wind, in order to cool you down. If your studio has the option, see if you can get some good air circulation or a fan on you, so that the sweat doesn't bother you as much.
I tend to have dry skin, but I live in a very wet climate (BC, anyone? We're having a rain storm right now!), so I had to learn which kind of pole finish was best for me, and also learn about applying my moisturizers, and drinking water, so that I don't need to apply too much. If I'm poling, I don't moisturize that day, or I'll wait till after pole.