Ah, found the problem. I'm running postgresql 7.2.1 (standard on Debian Woody (current stable)). The problem reported by Servoy when trying to upgrade the repository is:
- Code: Select all
com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException:
ERROR: parser: parse error at or near ""
Not finding that very informative, we looked elsewhere, starting with postgresql query logging:
- Code: Select all
Mar 15 14:35:26 osprey postgres[15373]: [70] DEBUG: query: alter table servoy_releases drop column release
Mar 15 14:35:26 osprey postgres[15373]: [71] ERROR: parser: parse error at or near ""
Bingo! That'll be because Postgresql 7.2 doesn't support "ALTER TABLE DROP COLUMN"
See:
http://www.postgresql.org/docs/7.2/stat ... table.html
So, the precise question becomes: Is upgrading a repository in Postgresql 7.2.1 supported?
Thanks,
Neale.