BUG #2910: Setting timestamps to null doesn't work with PDO - Mailing list pgsql-bugs

From Michael Vogel
Subject BUG #2910: Setting timestamps to null doesn't work with PDO
Date
Msg-id 200701190931.l0J9VrmM006054@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2910
Logged by:          Michael Vogel
Email address:      icarus@dabo.de
PostgreSQL version: 8.2.1
Operating system:   Windows
Description:        Setting timestamps to null doesn't work with PDO
Details:

Hi!

We are having problems, setting timestamp fields to "Null" with PDO (Visual
Basic 6)

The following code doesn't work, it reports an invalid date/time-value.

-----------------------------
strSql = "Select * From auftrag Where nummer In('0131') Order By nummer"

Set ds1 = objHMVBDV.ADOConnection.OpenRecordset(strSql, adOpenDynamic,
adLockOptimistic)
   ds1.Fields("erloeseaufgebautam") = Null
   ds1.Update
Set ds1 = Nothing

-----------------------------
Setting the field to "null" with an SQL-statement works ("update ..."). It
doesn't work with 8.2.0 and 8.2.1 but does work with 8.0.x.

The server is running under Linux in version 8.2.0, the clients are running
Windows XP.

Michael

pgsql-bugs by date:

Previous
From: "Aravind"
Date:
Subject: BUG #2912: postgres database connectivity
Next
From: Milton César de Souza Leite
Date:
Subject: PostgreSQL & Slackware