Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' etc..

Getting error while trying to insert date with the format 'dd-month-yyyy' , 'day-mm-yyyy' (format which add the space in between the date ) etc.. 

Testcase:
========
postgres=# \d t
     Table "public.t"
  Column | Type | Modifiers 
--------+------+-----------
 a      | date | 

postgres=# insert into t values ( to_char(current_date+2, 'day-mm-yyyy')::date); 
ERROR:  invalid input syntax for type date: "friday   -06-2009"

postgres=# insert into t values ( to_char(current_date+2, 'dd-month-yyyy')::date);
ERROR:  invalid input syntax for type date: "12-june     -2009"


Debugged the issue and found that error coming from date_in() -> DecodeDateTime(). Problem here is whenever any space comes in the date ParseDateTime() unable to break string into tokens based on a date/time context.


-- 
Rushabh Lathia
www.EnterpriseDB.com