[ROL-910] Errors in PostgreSQL upgrade script and code for Roller 2.0

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.0
• Fix Version/s: 2.0.1
• Component/s: Data Model & JPA Backend, Installation & Configuration
• Database: PostgreSQL
• Assignee: David Johnson
• Reporter: David Johnson
• Created: 05/Dec/05 03:08
• Updated: 20/Mar/06 17:27
• Resolved: 21/Dec/05 16:03

Description

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:

• WEB-INF/lib/rollerbeans.jar
• WEB-INF/dbscripts/postgresql/130-to-200-migration.sql