have you checked the database?<br>Because it could be that there is an item in that collection that has been withdrawn ...<br><br><div><span class="gmail_quote">On 4/26/06, <b class="gmail_sendername">hong xu</b> <<a href="mailto:hgxu@hotmail.com">
hgxu@hotmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi, everyone:<br><br>Have you experienced this problem? I need a help! Thank you!
<br><br>There are three collections in one community. I want to delete one and in<br>that collection there is not items, but I can not delete it. system said<br>"experience an ERROR". I looked the log file and it recorded as the
<br>following:<br><br><br>ERROR: update or delete on "collection" violates foreign key constraint "$1"<br>on "collection2item"<br><br>org.postgresql.util.PSQLException: ERROR: update or delete on "collection"
<br>violates foreign key constraint "$1" on "collection2item"<br><br> at<br>org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)<br> at org.postgresql.core.QueryExecutor.executeV3
(QueryExecutor.java:152)<br> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)<br> at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)<br> at<br>org.postgresql.jdbc1.AbstractJdbc1Statement.execute
(AbstractJdbc1Statement.java:517)<br> at<br>org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)<br>......<br><br><br>_______________________________________________<br>Dspace-general mailing list
<br><a href="mailto:Dspace-general@mit.edu">Dspace-general@mit.edu</a><br><a href="http://mailman.mit.edu/mailman/listinfo/dspace-general">http://mailman.mit.edu/mailman/listinfo/dspace-general</a><br></blockquote></div><br>
<br clear="all"><br>-- <br>Lieven