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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match