Datetime and pgtypes.c

From: "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Datetime and pgtypes.c
Date: 2002-12-02 18:47:53
Message-ID: 1398.192.168.1.101.1038854873.squirrel@webmail.aldeiadigital.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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
The MyLog output the correct version:
[2560]Extracted PostgreSQL version number: '7.3'

In pgtypes.c (annotate version), we have:

momjian 1.22 case PG_TYPE_DATETIME:
hinoue 1.52 if (PG_VERSION_GE(conn, 7.0))
hinoue 1.52 return "timestamp with time
zone";
hinoue 1.52 else
hinoue 1.52 return "datetime";
inoue 1.47 case PG_TYPE_TIMESTAMP_NO_TMZONE:
hinoue 1.52 return "timestamp without time zone";

To correct this, I will need only to change the function
PG_VERSION_GE(conn, 7.3) or is a bug in the PG_VERSION_GE check
the GreatEqual version passed ???

Thank's again.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-12-03 00:40:19 Re: Datetime and pgtypes.c
Previous Message Hiroshi Inoue 2002-12-02 09:42:37 Re: BUG in Unicode Driver - was: Re: Can't get more than 255