Bug 104914
| Summary: | deprecated datetime-function in postgresql >7.2 avoids usage of postgresql-backend | ||
|---|---|---|---|
| Product: | [Retired] Red Hat Linux Beta | Reporter: | Lars Herrmann <herrmann> |
| Component: | gnucash | Assignee: | Bill Nottingham <notting> |
| Status: | CLOSED RAWHIDE | QA Contact: | |
| Severity: | medium | Docs Contact: | |
| Priority: | medium | ||
| Version: | beta1 | CC: | rvokal |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | 1.8.7-1 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2003-09-23 19:07:22 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
This is already fixed in later gnucash releases. Will be in 1.8.7-1. |
Description of problem: With gnucash you can not use postgresql as backend, because postgresql >7.2 does no longer support datetime('NOW'). Version-Release number of selected component (if applicable): gnucash-1.8.5-1.src.rpm How reproducible: try to save a gnucash account set to postgres://localhost/anydb. After the querie: shall I create your database? you get a error message. Postgresql says: function datetime("unknown") does not exit Additional info: The patch from http://www.mail-archive.com/gnucash-devel@lists.gnucash.org/msg02508.html works. I simply changed it in /usr/lib/gnucash/libgncmod-backend-postgres.so.0.0.0 and it worked.