I wanted to see if anyone else has run into the issue when upgrading to 1.6
(rc1) from 1.5.2, that

ERROR:  constraint "community2collection_collection_id_fkey" of relation
"community2collection" does not exist
ERROR:  constraint "community2community_child_comm_id_fkey" of relation
"community2community" does not exist
ERROR:  constraint "collection2item_item_id_fkey" of relation
"collection2item" does not exist

Only by commenting out three lines in
/dspace/etc/postgres/database_schema_15-16.sql does the db script execute
successfully.
-- ALTER TABLE community2collection DROP CONSTRAINT
community2collection_collection_id_fkey;
...
-- ALTER TABLE community2community DROP CONSTRAINT
community2community_child_comm_id_fkey;
...
-- ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey;

I cloned (backup/restore) the production server's dspace table for local
testing/development. The server version is PostgreSQL 8.1.11. My workstation
is 8.4.1

-- 
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to