Hello Jose,
this is for one item in a collection, in order to move all items in a collection, execute with backup of your db first:
1.update item set owning_collection=NewCollectionID where item_id in (select item_id from item where owning_collection=OldCollectionID);
2.update collection2item set collection_id=NewCollectionID where collection_id=OldCollectionID and item_id in (select item_id from item where owning_collection=OldCollectionID);
3. run index-update (not index-init) Hope that helps Claudia Jürgen Am 25.03.2010 18:45, schrieb Blanco, Jose:
I need to move all the items from one collection to another, and I'm going to do it from postgres, but before I do it, I want to make sure this is what I need to do. Could someone verify that I have not left anything out. 1) Run this SQL update item set owning_collection=NewCollectionID where item_id=ItemID; 2) Then run this SQL for all the items in the collection update collection2item set collection_id=NewCollectionID where collection_id=OldCollectionID and item_id=ItemID; 3) Finally run this index-init Thank you! Jose ------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
<<attachment: Claudia_Juergen.vcf>>
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
