Hi all,
upgrading a DSpace instance from 1.4 or lower to 1.5.x fails on the db
upgrade 1.4 to 1.5 for instances using Postgres versions lower 8.0 (the
documentation still refers to 7.3+ as prerequisite)
The command
ALTER TABLE BitstreamFormatRegistry ALTER COLUMN mimetype TYPE VARCHAR(256);
is not supported.
You got to use
ALTER TABLE BitstreamFormatRegistry ADD COLUMN mimetype_new
VARCHAR(256);
UPDATE BitstreamFormatRegistry SET mimetype_new = mimetype;
ALTER TABLE BitstreamFormatRegistry DROP COLUMN mimetype;
ALTER TABLE BitstreamFormatRegistry RENAME COLUMN mimetype_new TO
mimetype;
instead.
Maybe we should update the prerequisite section for the next release.
There seem to be more problems see
http://www.nabble.com/PSQLExeption:-ERROR:-relation-with-OID-...-does-not-exist-td20090811.html
Sunny Greetings
Claudia Jürgen
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
