From: | "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Datetime and pgtypes.c |
Date: | 2002-12-03 12:35:44 |
Message-ID: | 1196.200.225.213.129.1038918944.squirrel@webmail.ad2.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
First, the correct is ´timestamp with time zone´ and not
'timestamp without timezone'... Sorry.
I have a lot of CREATE scripts using ´datetime´
correctly in PG <= 7.2.3...PG convert automaticaly
to ´timestamp with time zone´.
But I can´t change the ´datetime´ in these scripts and
PG 7.3 remove this type.
If I send a "create foo (foo datetime)", PG 7.3 reports
´datetime´ does not exist. I only execute this statments
in win-odbc and not directly in psql.
Can ODBC convert automatically ´datetime´
to timestamp with time zone' or I have to create this type in PG 7.3
to convert it ?
Very thank´s, Mr. Hiroshi.
> alexandre :: aldeia digital wrote:
>>
>> Mr. Hiroshi and all,
>>
>> Sorry for report this bug again...The ODBC does not
>> convert 'datetime' type to 'timestamp without timezone'
>> for PostgreSQL 7.3
>
> How do you convert the 'datetime' type concretely ?
> Is the converted type still 'datetime' or 'timestamp with
> time zone' ? Note that 'datetime' is never converted to
> 'timetstamp without time zone'.
>
> regards,
> Hiroshi Inoue
> http://w2422.nsk.ne.jp/~inoue/
From | Date | Subject | |
---|---|---|---|
Next Message | mlw | 2002-12-03 12:44:17 | Re: Shrinkwrap Windows Product, any issues? Anyone? |
Previous Message | Mauro Goncalves de Oliveria | 2002-12-03 11:45:38 | Errors in build psqlODBC |