Upgrade Retain from 3.x to 4.x with Postgres database

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.

Manually update the database with the same command but "default true."

This article was originally published in the GWAVA knowledgebase as article ID 2803.