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

BUG #2910: Setting timestamps to null doesn't work with PDO

From: "Michael Vogel" <icarus(at)dabo(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2910: Setting timestamps to null doesn't work with PDO
Date: 2007-01-19 09:31:53
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

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


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,
   ds1.Fields("erloeseaufgebautam") = Null
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.


pgsql-bugs by date

Next:From: AravindDate: 2007-01-19 11:07:31
Subject: BUG #2912: postgres database connectivity
Previous:From: David LloydDate: 2007-01-19 05:55:12
Subject: BUG #2908: ISO8601 Date / Time Format Incompatibility

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