Hi Gustavo, the item is probably an unfinished submission. Check your list of pending submissions. If that doesn't help, you can do
DELETE FROM communities2item WHERE item_id=1984; and then try again deleting the item. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Fri, Jul 26, 2013 at 11:15 AM, Gustavo <gustavo.perosi...@uva.es> wrote: > I have update to Dspace 3.1 and when I try to delete an item, collection o > communitie, it show the message: > Excepción: > org.postgresql.util.PSQLException: ERROR: update o delete en «item» viola la > llave foránea «communities2item_item_id_fkey» en la tabla «communities2item» > Detail: La llave (item_id)=(1984) todavía es referida desde la tabla > «communities2item». > at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI > mpl.java:2103) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja > va:1836) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j > ava:512) > > ***************************** > Gustavo Perosillo Herrera > STIC- Universidad de Valladolid > Telefono: 983423418 > e-mail: gustavo.perosi...@uva.es > ********************************* > > > > > ------------------------------------------------------------------------------ > See everything from the browser to the database with AppDynamics > Get end-to-end visibility with application monitoring from AppDynamics > Isolate bottlenecks and diagnose root cause in seconds. > Start your free trial of AppDynamics Pro today! > http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
