Installing modules in OpenERP with PostgreSQL 8.3

When using OpenERP 4.2.2. with PostgreSQL 8.3, a few SQL errors appear when installing new modules, with SUBSTRING appearing with dates.

A solution is suggested here (by cornflake on the OpenERP forum). Basically, it consists in replacing all occurences of “substring(date for 7)” by “to_char(date, ‘YYYY-MM’)” in /usr/share/tinyerp-server/addons/


Related Posts

Installing OpenERP on Ubuntu – Creating databases

Following up on my last piece of news about the update put in...

Installing OpenERP on Ubuntu – Creating databases – Troubleshooting

I have updated the OpenERP wiki again to add documentation about the possible...