Terrific! Thanks, Adam. I’ll give it a go tomorrow. Best, Lily
On Apr 28, 2020, at 11:46 AM, Adam Lodge <[email protected]> wrote: Lily, The basics are this: *** delete from ontologies cascade where [some condition is met] *** A few points of note: - This will delete all ontologies meeting the where condition and any child records in other tables containing those ontologyid’s as foreign keys. - On the where condition, you will likely filter on ontologyid or name. - Before running the sql, delete any models or branches that reference the ontology you want to delete. If you don’t do that, this statement may delete them, but I can’t predict the consequences. - Probably obvious, but be sure to have a backout plan (like a db backup) in case of unintended consequences. Good luck! Adam --- Adam Lodge Geospatial Systems Consultant Farallon Geographics On Apr 28, 2020, at 10:47 AM, Adam Lodge <[email protected]<mailto:[email protected]>> wrote: Hi Lily, You are right. There is no Arches command, but I’ve done it before with sql. I’ll write something for you and send it your way. Best, Adam --- Adam Lodge Geospatial Systems Consultant Farallon Geographics On Apr 27, 2020, at 7:08 PM, Lily Pregill <[email protected]<mailto:[email protected]>> wrote: Hi, We have multiple versions of an ontology loaded in a v.5 instance. I'm doing a little house-keeping and would like to remove the unused, old ontology version. I checked the documentation but didn't see a command to remove an ontology, only to load one. Suggestions on how to accomplish this would be very much appreciated. Thank you! Lily -- -- To post, send email to [email protected]<mailto:[email protected]>. To unsubscribe, send email to [email protected]<mailto:[email protected]>. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/da14ee53-3ca7-4669-902d-5054f5ec596e%40googlegroups.com<https://groups.google.com/d/msgid/archesproject/da14ee53-3ca7-4669-902d-5054f5ec596e%40googlegroups.com?utm_medium=email&utm_source=footer>. -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/3927E10E-4B9A-4A5A-B2EF-678DA6FE18BE%40fargeo.com<https://groups.google.com/d/msgid/archesproject/3927E10E-4B9A-4A5A-B2EF-678DA6FE18BE%40fargeo.com?utm_medium=email&utm_source=footer>. -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/8768FE70-1558-47D1-A9C8-126FE709D273%40getty.edu.
