Post Malone revealed his fiancee's initial rejection of his marriage proposal, citing his intoxicated state as the reason