Revision 6980
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 650 | 650 |
WHERE ancestor_id = higher_plant_group_id |
| 651 | 651 |
AND rank = 'family' |
| 652 | 652 |
AND source_id = source_id_ |
| 653 |
AND taxonepithet IS NOT NULL |
|
| 653 | 654 |
LOOP |
| 654 | 655 |
BEGIN |
| 655 | 656 |
INSERT INTO family_higher_plant_group |
Also available in: Unified diff
schemas/vegbien.sql: make_family_higher_plant_group(): Added `taxonepithet IS NOT NULL` filter, to allow make_analytical_db to proceed even when the NCBI import fails (leaving some nodes with rank = 'family' but no associated taxonepithet). The most recent NCBI import failed due to the search_path/DuplicateException bug resulting from the import schema and public being in the search_path together.