Pipe dream
A dream that usually occurs during a short nap that leaves its victim with a large and often untimely errection.
That pipe dream came at the wrong time, now i have to hide my wood for an hour.