The driver does not convert a statment like:
CREATE TABLE FOO (DTAAA datetime)
to
CREATE TABLE FOO (DTAAA timestamp)
Postgre 7.3 remove the datetime type. Use:
CREATE DOMAIN datetime AS timestamp
in your database (and in template1) to solve this.
Regards,
Alexandre
> Sorry for the
>
> "William S. Bear" wrote:
>>
>> I'm trying to export an access database to postgres 7.3,
>> but get an error that datatype datetime does not exist.
>> Noticed in the docs that 7.3 will not longer support
>> datetime data type. Will the ODBC driver be converting
>> all datetime datatypes to timestamp in future versions?
>
> Which version of psqlodbc driver are you using ?
> The current driver converts datetime type to timestamp.
>
> regards,
> Hiroshi Inoue
> http://w2422.nsk.ne.jp/~inoue/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster