Skip to end of banner
Go to start of banner

MODSOURMAN-632 Create a script to delete duplicate mapping rules for each record type

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Script to delete duplicated mapping rules by record type:

Delete duplicated mapping rules
DELETE FROM
diku_mod_source_record_manager.mapping_rules a
USING diku_mod_source_record_manager.mapping_rules b
WHERE a.id < b.id AND a.record_type = b.record_type
RETURNING a.id, a.record_type;


  • No labels