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

BUG #2509: ODBC TIMESTAMP UPDATE FAILED

From: "ONG JIIN ME" <JM(at)MicroTech2u(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2509: ODBC TIMESTAMP UPDATE FAILED
Date: 2006-07-02 10:38:38
Message-ID: 200607021038.k62AcccB073959@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2509
Logged by:          ONG JIIN ME
Email address:      JM(at)MicroTech2u(dot)com
PostgreSQL version: 8.1.4
Operating system:   WIN XP PRO SP 2
Description:        ODBC TIMESTAMP UPDATE FAILED
Details: 

Using adodb recordset.update to update a timestamp field failed.

TESTING STEP :
1. Using Postgresql Unicode ODBC Driver
2. Using VB6 coding as below to test
rec.open "SELECT last_modified FROM X WHERE id=1",con,3,2
rec(0) = Now
rec.update
3. Prompt "update failed... cannot find update row"

The fact is, I found that I can successfully update as specified in step 2
if I set the last_modified into null before update. However, the value of
last_modified has no "TIME", only "DATE" stored.

The second fact is, ADDNEW has no problem, only UPDATE existing record has
the problem stated.

Thank you for advance.

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-07-03 01:55:06
Subject: Re: Bug#372115: Last security update of postgresql-contrib
Previous:From: Soner DemirayDate: 2006-07-01 14:58:43
Subject: BUG #2508: TransactionIdGetStatus returns wrong state

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