connorjoleary / DeepCite

Traversing links to find the deep source of information
GNU General Public License v3.0
69 stars 7 forks source link

Foreign key issue #109

Closed connorjoleary closed 2 years ago

connorjoleary commented 2 years ago

Describe the bug The foreign key constraint on the source_label table references the deepcite_retrieval table and not the deepcite_call table. This means that if someone labels info off of an original call, the sources are not saved and instead this error is returned:

2021-09-04 01:35:18.246 UTC [611385]: [1-1] db=postgres,user=postgres ERROR: insert or update on table "source_label" violates foreign key constraint "source_label_base_id_fkey"

Expected behavior There should be two columns in this table. One source id which references deepcite_call and one nullable which references deepcite_retrieval.