It doesn't sound like you're doing anything wrong. It sounds like the error is that somewhere we are asking Postgres to do an implicit conversion from string->date and it doesn't want to. We do usually try do convert to the correct type before handing off to Postgres.

Can you send me the .sql script you used to create your table? If you can find this error in the log and send that along that will help a lot.

Matt