Why invite trouble?
LEO are forced by the nature of the job, to go places that are dangerous and where they may need a gun. NOTE: they do not drink while doing this, they practice this situational stuff, and they generally go with a partner or backup.
Average citizens are well advised not to go places where they may need a gun. I carry and am not advocating that you stop doing so, so long as it is legal. But you should never go seeking trouble. Why would you voluntarily go somewhere you:
a) intend to become intoxicated
B) will be around others also intoxicated whose behavior you can't control
c) know there is an element of danger
d) expect to need your gun.
The simplest rational solution is not to go. If you go, store your gun safely before your first drink and do not take it with you. In most places, even if CCW is legal, doing so under the influence of drugs or alcohol is illegal. Also, a drunk with a gun in a drunken crowd is a recipe for disaster, yours or someone elses.