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
