Environment
Retain 4.x
PostgreSQL
Situation
When upgrading from Reatain 3.x to 4.x the schema update tries to create a new table "t_smtpforward", however the column "attachmentProcessed" is boolean and the create table statement has it as "default 1" - that doesn't work in PostgreSQL.
Resolution
Manually update the database with the same command but "default true."
Additional Information
This article was originally published in the GWAVA knowledgebase as article ID 2803.