Posted By: Erik Hollensbe
Date: 2008-10-03 03:52
Summary: DBD::Pg timestamp conversion issues
Project: Ruby/DBI

timestamp conversion for DBD::Pg is currently broken; if you do not accept 'mdy' dates, you should get an error; if you accept 'dmy' dates, you may encounter corruption if you try and insert or update with DateTime objects.

The fix is mildly complicated, and cannot be done immediately. Meanwhile, you have your choice of interim solutions: you can either set convert_types to false (on DBI, the database handle, or statement handle) or pass a string with the appropriate format.

We understand that this is more than an inconvenience, and apologize for that; we are committed to fixing this as soon as possible and DBI 0.4.1 will likely be released as a consequence of this bug. Please be patient.

Latest News
TZInfo::Data v1.2014.2 Released
    Philip Ross - 2014-03-25 22:32
TZInfo v0.3.39 Released
    Philip Ross - 2014-03-09 20:23
TZInfo::Data v1.2014.1 Released
    Philip Ross - 2014-03-09 20:00
Automatic Ruby 14.2.0 has been released!
    id 774 - 2014-02-26 06:23
kramdown 1.3.2 released
    Thomas Leitner - 2014-02-16 08:35

 

Forums | Admin

Discussion Forums: dbd--pg-timestamp-conversion-issues

Start New Thread Start New Thread

 

Topic Topic Starter Replies Last Post