Melalcoholic
A melalcoholic or melanchaholic person is someone who gets melancholic while they're getting drunk.
Drunk: Hey remember that time when we knocked on everybody's doors around 5 AM? I wish I could still do that kinda stuff
Another drunk: Yeah sure, but it's only a melalcoholic dream.
Another drunk: Yeah sure, but it's only a melalcoholic dream.