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

  • 7019099
  • 31-May-2016
  • 07-Aug-2017

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.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.