Taxonomy database update fails
Updating Taxonomy from the most recent available GRIN Taxonomy dump results in:
Cannot insert duplicate key row in object 'dbo.taxonomy_species' with unique index 'ndx_uniq_ts'. The duplicate key value is (Gordonia spp., ).
This is a result of spp.
registered with different Gordonia
genus with different name authorities.
Please remove the current unique index taxonomy_species.ndx_uniq_ts
and replace it with a new unique index ndx_uniq_ts
in columns: name
, name_authority
, taxonomy_genus_id
.