Error with Foreign Keys | marcia hon | 2019-02-28 11:44 | |||||||||
Status: Closed | |||||||||||
This issue happens sometimes with different values, and I don't understand why this happens: I have a custom table created via ETL. It has a column that references a lookup table. When I put legitimate data into this column, I get the following error: SqlExecutor.execute(); SQL []; ERROR: insert or update on table "samples_samplesnotreceived" violates foreign key constraint "fk_samsamnotrecdiagnosis1" "Hallucinogen Persisting Perception Disorder" is indeed in the "diagnosis" table but it is unable to recognize it. Please let me know how to correct this. Thanks, |
|||||||||||
| |||||||||||