Hi All,
I am trying to upgrade my DSpace instance from version 1.4.2 to 1.5.0. When updating the database schema using the /dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql file, the execution is resulting in the dropping of views, which impacts on the running of the updated DSpace instance. Here is the except from the update: $psql -U dspace -f /dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql dspace ALTER TABLE UPDATE 68 ALTER TABLE ALTER TABLE ALTER TABLE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:80: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "collection_item_count_pkey" for table "collection_item_count" CREATE TABLE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:85: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "community_item_count_pkey" for table "community_item_count" CREATE TABLE DROP SEQUENCE DROP SEQUENCE DROP SEQUENCE DROP SEQUENCE DROP SEQUENCE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: NOTICE: drop cascades to rule _RETURN on view communityitemsbyauthor psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: NOTICE: drop cascades to view communityitemsbyauthor psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: NOTICE: drop cascades to rule _RETURN on view collectionitemsbyauthor psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:97: NOTICE: drop cascades to view collectionitemsbyauthor DROP TABLE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: NOTICE: drop cascades to rule _RETURN on view communityitemsbytitle psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: NOTICE: drop cascades to view communityitemsbytitle psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: NOTICE: drop cascades to rule _RETURN on view collectionitemsbytitle psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:98: NOTICE: drop cascades to view collectionitemsbytitle DROP TABLE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: NOTICE: drop cascades to rule _RETURN on view communityitemsbydate psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: NOTICE: drop cascades to view communityitemsbydate psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: NOTICE: drop cascades to rule _RETURN on view collectionitemsbydate psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:99: NOTICE: drop cascades to view collectionitemsbydate DROP TABLE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: NOTICE: drop cascades to rule _RETURN on view communityitemsbydateaccession psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: NOTICE: drop cascades to view communityitemsbydateaccession psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: NOTICE: drop cascades to rule _RETURN on view collectionitemsbydateaccession psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:100: NOTICE: drop cascades to view collectionitemsbydateaccession DROP TABLE psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: NOTICE: drop cascades to rule _RETURN on view communityitemsbysubject psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: NOTICE: drop cascades to view communityitemsbysubject psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: NOTICE: drop cascades to rule _RETURN on view collectionitemsbysubject psql:/dspace-1.5.0-src-release/dspace/etc/database_schema_14-15.sql:101: NOTICE: drop cascades to view collectionitemsbysubject DROP TABLE DROP TABLE DROP TABLE As a results, I end up with two views instead of 12 as in DSpace 1.4.2. Is this correct? I cannot views items after the upgrade as I get the "communityitemsbydate relation not found" error. Kind Regards, Admire Mutsikiwa (Mr) ICT Projects Manager Library IT University of Zimbabwe Tell:+263-4-303276 Cell:+263-92239187 Alt/email:amutsik...@gmail.com
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech