To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110723 Issue #|110723 Summary|SDBC Driver Date Problem Component|Database access Version|OOo 3.2 Platform|Other URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|jbu Reported by|geoff91880
------- Additional comments from geoff91...@openoffice.org Fri Apr 9 12:12:48 +0000 2010 ------- Versions: SDBC: 0.7.6a PostgreSQL: 8.4.2 OpenOffice.org: 3.2.0 (320m12) Build: 9483 Platform: Linux Kernel (Ubuntu 10.04 Beta 2) SDBC driver is not permitting inserts (or updates) of PostgreSQL type DATE. For instance, update fails with the following message: "Error updating the current record pg_preparedstatement::setObjectWithInfo: can't convert value of type com.sun.star.util.Date to type DECIMAL or NUMERIC" As far as I can tell it looks like the driver is attempting to CAST the input value and PostgreSQL is rejecting that for the field of type DATE. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org