I've heard the version that Richard McD. Bridge refers to sung by Gregg Clarke from the Albany area (who knows more obscure songs than anyone!). He learned it from Michael Cooney.
It's the only version I've come across in which the husband (who's NOT drunk)gets his revenge (the trusty 12-bore). The best verse is the one that takes place in the bed, where the fellow spots someone's "bum." The wife replies that it's only a pumpkin, and the punch line is "But pimples on a pumpkin I never saw before." Gregg gives the name of the song as Pimples on a Pumpkin.
Jerry