Re: [Dspace-tech] 1.6 upgrade DB constraint errors
Hello Peter, a bit late, but just ran into the same problem while testing an upgrade. Rather than uncommenting the lines you should drop the constraints with: ALTER TABLE community2collection DROP CONSTRAINT $2; ALTER TABLE collection2item DROP CONSTRAINT $2; ALTER TABLE community2community DROP CONSTRAINT $2; Hope that helps Claudia Jürgen Am 18.12.2009 00:33, schrieb Peter Dietz: 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 -- 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 attachment: Claudia_Juergen.vcf-- ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] 1.6 upgrade DB constraint errors
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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] 1.6 upgrade DB constraint errors
Hi Peter, this sql is intended to fix the name of some constraint that we need to make deferrable. The drop sentence is make with the assumption that postgres has created the foreign key with a standard syntax, this is which that I have seen on many postgres instances that I run on my workstation and production, development server... maybe this could be (postgres) version or configuration depending? can you share the full DDL of your tables community2collection, community2community and collection2item as appear in your production database? Thanks, Andrea Peter Dietz ha scritto: 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 DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Dott. Andrea Bollini Project Manager, IT Architect Systems Integrator Sezione Servizi per le Biblioteche e l'Editoria Elettronica CILEA, http://www.cilea.it tel. +39 06-59292853 cel. +39 348-8277525 --- Disclaimer: the content of this email is confidential and may be privileged, and it must not be disclosed or copied without the sender's consent. If you have received this message in error, please notify the sender and remove it from your system. The content of this email does not constitute legal advice, nor any responsibility is accepted for loss or damage incurred as a result of acting upon its contents or attachments. The statements and opinions expressed in this email are those of the author and do not necessarily reflect those of the employer. -- 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