[Dspace-general] foreign key constraint

[Lieven Droogmans]

have you checked the database?
Because it could be that there is an item in that collection that has been
withdrawn ...

On 4/26/06, hong xu <hgxu at hotmail.com> wrote:
>
> Hi, everyone:
>
> Have you experienced this problem? I need a help! Thank you!
>
> There are three collections in one community. I want to delete one and in
> that collection there is not items, but I can not delete it. system said
> "experience an ERROR". I looked the log file and it recorded as the
> following:
>
>
> ERROR: update or delete on "collection" violates foreign key constraint
> "$1"
> on "collection2item"
>
> org.postgresql.util.PSQLException: ERROR: update or delete on "collection"
> violates foreign key constraint "$1" on "collection2item"
>
>         at
> org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
>         at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java
> :152)
>         at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java
> :100)
>         at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java
> :43)
>         at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(
> AbstractJdbc1Statement.java:517)
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
> AbstractJdbc2Statement.java:50)
> ......
>
>
> _______________________________________________
> Dspace-general mailing list
> Dspace-general at mit.edu
> http://mailman.mit.edu/mailman/listinfo/dspace-general
>



--
Lieven
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/dspace-general/attachments/20060426/b396efb6/attachment.htm