Thank you for sharing this information. Asko Soukka wrote:
>Hi, > >I've been running tests for upgrading our DSpace 1.4.2 installation to >1.6.x while remaining on PostgreSQL 7.4. For the upgrade steps to >succeed I had to make a couple of changes to the database schema >migration steps because PSQL 7.4 doesn't seem to support 1) changing a >data type of an existing column 2) setting a default value when adding a >new column. > >Otherwise, it seems that the upgrading steps work as supposed also when >upgrading from 1.4.2 directly to 1.6.x. > >I hope this helps someone. > >Best Regards, >Asko > >1) >--- a/database_schema_14-15.sql 2010-03-02 18:41:16.000000000 +0000 >+++ b/database_schema_14-15.sql 2010-04-15 07:42:39.000000000 +0000 >@@ -65,7 +65,11 @@ > -- Increase the mimetype field size to support larger types, such as the > -- new Word 2007 mimetypes. > ------------------------------------------------------------------------- >-ALTER TABLE BitstreamFormatRegistry ALTER COLUMN mimetype TYPE >VARCHAR(256); >+ALTER TABLE BitstreamFormatRegistry ADD COLUMN mimetype_new VARCHAR(256); >+UPDATE BitstreamFormatRegistry SET mimetype_new = mimetype; >+ALTER TABLE BitstreamFormatRegistry RENAME mimetype TO mimetype_old; >+ALTER TABLE BitstreamFormatRegistry RENAME mimetype_new TO mimetype; >+ALTER TABLE BitstreamFormatRegistry DROP COLUMN mimetype_old; > > > ------------------------------------------------------------------------- > >2) >--- a/database_schema_15-16.sql 2010-03-02 18:41:16.000000000 +0000 >+++ b/database_schema_15-16.sql 2010-04-15 07:13:50.000000000 +0000 >@@ -53,7 +53,10 @@ > -- DS-236 schema changes for Authority Control of Metadata Values > ------------------------------------------------------------------------- > ALTER TABLE MetadataValue ADD authority VARCHAR(100); >-ALTER TABLE MetadataValue ADD confidence INTEGER DEFAULT -1; >+ALTER TABLE MetadataValue ADD confidence INTEGER; >+UPDATE MetadataValue SET confidence = -1; >+ALTER TABLE MetadataValue ALTER COLUMN confidence SET DEFAULT -1; >+ALTER TABLE MetadataValue ALTER COLUMN confidence SET NOT NULL; > > ------------------------------------------------------------------ > -- New tables /sequences for the harvester functionality (DS-289) > >------------------------------------------------------------------------------ >Download Intel® Parallel Studio Eval >Try the new software tools for yourself. Speed compiling, find bugs >proactively, and fine-tune applications for parallel performance. >See why Intel Parallel Studio got high marks during beta. >http://p.sf.net/sfu/intel-sw-dev >_______________________________________________ >DSpace-tech mailing list >DSpace-tech@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/dspace-tech > > ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech