Hello Stanislav, you most likely did not run into the problem, because you never tried to delete anything. There might be issues with collection2item, community2community, too if my guess is right that this was this old issue: http://dspace.2283337.n4.nabble.com/Dspace-tech-running-the-15-to-16-script-td3280357.html
Since DSpace 5 there is a database command line tool which can a) info about the db (including missing/faild migration) b) repair the db (trying to run migrations) But you are using 4. I'm no DB expert just know some basic stuff so anybody out there knowing a tool/elegant solution? At the moment you can compare your database with the database schema of DSpace, first identifying the discrepancies. You can generate a description of your db with pg_dump --schema-only --no-owner Your_Database_Name > YourDatabaseCreation.sql If it is really only the above mentioned constraints which are screwed up, follow the instructions in the thread above, with the usual warning about backing up everything properly first. Hope this helps Claudia Jürgen Am 07.05.2018 um 20:46 schrieb Stanislav Orlov: Thank you Claudia, We started ten years ago and went through a few upgrades. I can see how this problem might have been created during the process, but we never ran into the problem until now. If I look at foreign keys for community2collection table, I see this: Name: community2collection_community_id_fkey Fields: community_id Referenced Schema: public Referenced Table: community Referenced Fields: community_id On Delete: NO ACTION On Update: NO ACTION What do I need to do to fix this? Stan -- Claudia Juergen Eldorado Technische Universität Dortmund Universitätsbibliothek Vogelpothsweg 76 44227 Dortmund Tel.: +49 231-755 40 43 Fax: +49 231-755 40 32 claudia.juer...@tu-dortmund.de<mailto:claudia.juer...@tu-dortmund.de> www.ub.tu-dortmund.de<http://www.ub.tu-dortmund.de> Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und vernichten Sie diese Mail. Vielen Dank. Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen Schriftstücks per Telefax erfolgen. Important note: The information included in this e-mail is confidential. It is solely intended for the recipient. If you are not the intended recipient of this e-mail please contact the sender and delete this message. Thank you. Without prejudice of e-mail correspondence, our statements are only legally binding when they are made in the conventional written form (with personal signature) or when such documents are sent by fax. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
