| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-07-03 01:55:06 | Re: Bug#372115: Last security update of postgresql-contrib |
| Previous Message | Soner Demiray | 2006-07-01 14:58:43 | BUG #2508: TransactionIdGetStatus returns wrong state |