Make PostGIS provider correctly create time and datetime formats

At the moment the postgis provider converts time and datetime fields to varchar fields. I'm not sure what the rationale behind this is. This patch correctly maps the datetime and time types to postgis timestamp and time types.