Add psycopg2 type overrides to DBAPI

Same thing here -- I don't actually think value can be None since it's only called if it's a date type (or in adapt_psycopg2_date -- but I don't think you can construct a psycopg2.Date without valid arguments, either). Willing to be convinced though.