FAQ: Teamwork and PostgreSql

Tests on PostgreSQL 8.3+ have shown that due to a change in default casting behavior, Teamwork’s database must be configured with:

CREATE FUNCTION int_to_text(INT4) RETURNS TEXT AS

'SELECT textin(int4out($1));'

LANGUAGE SQL STRICT IMMUTABLE;

CREATE CAST (INT4 AS TEXT)

WITH FUNCTION int_to_text(INT4) AS IMPLICIT;

If you are upgrading to Teamwork 4.7 probably you already have this function on your database as it was already required by previous Teamwork versions.

Once you have created this function on your Teamwork database you have to download the following zipped folder:

http://dl.open-lab.com/PostgreSql.zip

Unzip it and replace the files contained in this folder (you find instructions also there) in the following paths. Then restart the Teamwork service. Backup your Teamwork folder and your Teamwork database first as described here:

http://www.twproject.com/upgradeFaq.page#upg4

Here is the list of the files that needs to be replaced:

AuditLogRecord.class - > Your_Teamwork_Folder/webapps/ROOT/WEB-INF/classes/org/jblooming/logging

PersistentText.class - > Your_Teamwork_Folder/webapps/ROOT/WEB-INF/classes/org/jblooming/ontology

IssuePersistent.class -> Your_Teamwork_Folder/webapps/ROOT/WEB-INF/classes/com/twproject/task

IssueHistory.class - > Your_Teamwork_Folder/webapps/ROOT/WEB-INF/classes/com/twproject/task

DiscussionPoint.class -> Your_Teamwork_Folder/webapps/ROOT//WEB-INF/classes/com/twproject/meeting

ForumEntry.class - > Your_Teamwork_Folder/webapps/ROOT//WEB-INF/classes/com/opnlb/website/forum

This operation is needed to a known bug of the last final release of Hibernate (the one used by Teamwork): More details here:

http://opensource.atlassian.com/projects/hibernate/browse/HHH-6105