Revision 5828
Added by Aaron Marcuse-Kubitza over 11 years ago
vegbien.my.sql | ||
---|---|---|
338 | 338 |
|
339 | 339 |
|
340 | 340 |
-- |
341 |
-- Name: taxonlabel_update_ancestors(taxonlabel, int(11)); Type: FUNCTION; Schema: public; Owner: - |
|
341 |
-- Name: taxonlabel_update_ancestors(taxonlabel, int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
|
|
342 | 342 |
-- |
343 | 343 |
|
344 | 344 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel_update_ancestors(): Include ancestors for both parent_id and matched_label_id rather than just one or the other. This avoids needing to delete existing ancestors for the parent_id when a matched_label_id is added and overrides it. This should reduce the TNRS import time if the slowdown was due to the need to delete parent_id ancestors when later adding a matched_label_id (which only occurs in a separate step in the TNRS datasource).