Sounds like you definitely have something in your metadatavalue table. Try doing a select of all records in the table and see if you have one where metadata_field_id = 5 (ours is contributor.illustrator).
Sue Walker-Thornton (w): (757) 864-2368 (m): (757) 506-9903 From: Smith, Ina <[email protected]> [mailto:[email protected]] Sent: Tuesday, March 26, 2013 8:41 AM To: [email protected]; [email protected] Subject: [Dspace-general] Delete field from DC Metadata Registry in DSpace Dear all I want to delete a metadata filed from the Dublin Core Registry from our repository. There is the option to delete a field. For some reason it isn't working. I've also tested it on a clean installation. Any advice? The error I get: org.postgresql.util.PSQLException: ERROR: update or delete on table "metadatafieldregistry" violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on table "metadatavalue" Detail: Key (metadata_field_id)=(5) is still referenced from table "metadatavalue". What kind of change do we need to make? Many, many thanks. Ina Ina Smith E-Research Repository Manager (SUNScholar) | Stellenbosch University | Private Bag X5036, 7599 | South Africa SUNScholar<http://scholar.sun.ac.za/> | SUNJournals<http://library.sun.ac.za/English/services/az/oa/Pages/sunjournals.aspx> | SUNConferences<http://library.sun.ac.za/Afrikaans/services/az/oa/Pages/sunconferences.aspx> | E-mail: [email protected]<mailto:[email protected]> | Tel: +27 21 808 9139 | Skype: smith.ina | Office hours: Mo-Fr: 08h00-16h30 E-Navorsingsbewaarplekbestuurder (SUNScholar) | Universiteit Stellenbosch | Privaatsak X5036, 7599 | Suid-Afrika SUNScholar<http://scholar.sun.ac.za/> | SUNJournals<http://library.sun.ac.za/English/services/az/oa/Pages/sunjournals.aspx> | SUNConferences<http://library.sun.ac.za/Afrikaans/services/az/oa/Pages/sunconferences.aspx> | E-pos: [email protected]<mailto:[email protected]> | Tel: +27 21 808 9139 | Skype: smith.ina | Kantoorure: Mo-Fr: 08h00-16h30 [cid:[email protected]] ________________________________ E-pos vrywaringsklousule Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie e-pos en/of die oopmaak van enige lêers aangeheg by hierdie e-pos nie. E-mail disclaimer This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.
<<inline: image001.jpg>>
------------------------------------------------------------------------------ Own the Future-Intel® Level Up Game Demo Contest 2013 Rise to greatness in Intel's independent game demo contest. Compete for recognition, cash, and the chance to get your game on Steam. $5K grand prize plus 10 genre and skill prizes. Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
