Re: datetime to timestamp

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