search

gbif / model-tests

Exploration of sample models
2 stars 0 forks source link

Missing agents #2

Closed timrobertson100 closed 2 years ago

timrobertson100 commented 2 years ago

The Agent table misses entries that are referenced in identification_agent_role. For example:

DETAIL:  Key (agentID)=(21249316) is not present in table "agent".

Can you please explore @tucotuco ?

timrobertson100 commented 2 years ago

This remains an issue 

arctos=# ALTER TABLE identification_agent_role ADD FOREIGN KEY ("agentID") REFERENCES agent ("agentID");        
ERROR:  insert or update on table "identification_agent_role" violates foreign key constraint "identification_agent_role_agentID_fkey"
DETAIL:  Key (agentID)=(10014238) is not present in table "agent".