PostgreSQL users upgrading from Roller 1.3 to Roller 2.0 run into fatal errors during Roller startup.
There are two parts to the problem:
- The first query in upgradeTo200() is not compatible with PostgreSQL
- The 130-to-200 script for PostgreSQL has multiple errors in the ALTER TABLE statements
I've got a fix for this. At a mininum, we'll need to provide fixes for these files: