Common DB Operations
Some common database operations.
Merging Duplicate Candidates
Merging duplicate candidates is pretty straight forward with the appropriate function. It moves all related data from one candidate to another.
NOTE: Nothing in the candidate table will be moved. This is up to Research to do.
BEGIN;
SELECT pvs_merge_candidate([duplicate_id], [destination_id]);
COMMIT;
SELECT pvs_merge_candidate([duplicate_id], [destination_id]);
COMMIT;
duplicate_id is the candidate_id that was created as a duplicate and no longer wanted. destination_id is where you want things moved(also a candidate_id).
CategoryITDoc
