To dream of a pumpkin implies open-mindedness to new ideas and experiences. A pumpkin is also closely associated with the female sexuality.
Alternatively, it calls to mind Cinderella, in which a fairy turns a pumpkin into a carriage. The carriage reverted back to a pumpkin at midnight. This represents a situation where time has run out.