You can be friendly and positive with them, but you have to have more distance than with your best friends. A manager needs to be in a position to be able to deal with disciplinary issues, challenge lateness or sloppy behaviour, etc etc and you can't do that to a close friend.
I'm really good friends with someone I used to be manager to, now we have both left the company we worked for and have no professional connection to each other.