If a handle gets deleted sets the resource_id to null and keep all the other 
information (basically resource_type and the handle itself). If something with 
an handle is getting restored from an AIP backup, DSpace checks whether the 
resource_type_id of the handle in the database is the same as of the 
DSpaceObject being restored from AIP. Handles are Persistent Identifier. Nobody 
wants a persistent identifier to change, because then it wouldn't be persistent 
anymore. ;-) That is the reason DSpace ensures that at least the resource_type 
of a deleted and restored handle doesn't change. I won't delete them as they 
don't disturbe you and as it is wanted behavior.

Regards,
  Pascal

From: Monika C. Mevenkamp [mailto:[email protected]]
Sent: Monday, February 02, 2015 3:25 PM
To: [email protected] Tech
Subject: [Dspace-tech] HANDLE table entries without resource_id

the query

SELECT HANDLE_ID, RESOURCE_TYPE_ID, RESOURCE_ID, HANDLE  FROM HANDLE WHERE 
RESOURCE_ID  IS NULL;

finds a couple entries

Is there a reason why I should not delete them ?

Monika

________________
Monika Mevenkamp
phone: 609-258-4161
693 Alexander Road, Princeton University, Princeton, NJ 08544

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
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

Reply via email to