cancel
Showing results for 
Search instead for 
Did you mean: 

DB Upgrade to 5.9 fails on PostgreSQL Database

pcsquirrel
Champ in-the-making
Champ in-the-making
DB Upgrade to 5.9 fails on PostgreSQL Database with the following Exception:

"couldn't upgrade db schema: update ACT_GE_BYTEARRAY set GENERATED_ = 0"

Resulting in PSQLException
"FEHLER: Spalte »generated_« hat Typ boolean, aber der Ausdruck hat Typ integer
  Hinweis: Sie müssen den Ausdruck umschreiben oder eine Typumwandlung vornehmen.
  Position: 42"

The problem is in "activiti.postgres.upgradestep.58.to.59.engine.sql"

Line 58:

update ACT_GE_BYTEARRAY set GENERATED_ = 0;

should be

update ACT_GE_BYTEARRAY set GENERATED_ = false;


Kind regards
Philipp Eichhorn
1 REPLY 1

frederikherema1
Star Contributor
Star Contributor
Thanks for reporting. Fixed in http://jira.codehaus.org/browse/ACT-1143