Skip site navigation (1) Skip section navigation (2)

time problem with postgres ODBC driver (fwd)

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: time problem with postgres ODBC driver (fwd)
Date: 2002-02-12 17:43:12
Message-ID: Pine.LNX.4.33.0202120942580.25714-100000@visor.corp.nextbus.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Repost...sorry if it goes to the list twice.

We are seeing a problem with the ODBC driver.

Using this table:

create table tst
( col1 date,
  col2 time);

and inserting values (rows) into the date and time columns.

When using the PostreSQL ODBC driver version 07.01.0007 against both a 7.2
and 7.1.3 database server, a select * from tst returns the date value for
col1 correctly, but returns the current date for col2 (which obviously is
wrong).

Interestingly, we have a system that has (had) a driver we had downloaded
from GreatBridge ODBC and it was working fine until we installed the PostgreSQL
driver onto it.

Is this a known problem? Any ideas?

Thanks,
-- 
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere





Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2002-02-12 18:22:43
Subject: Re: time problem with postgres ODBC driver (fwd)
Previous:From: Dave PageDate: 2002-02-12 10:26:19
Subject: Re: Installing and configuring postgreSQL and ODBC on Red

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group