Loading

I am running a SQL dump file and im getting this error: insert or upda

Sanjay Kumar

I am running a SQL dump file and im getting this error:
insert or update on table "section_charts" violates foreign key constraint "fklin6rl906fxfxcp9jq9xie98r"
DETAIL: Key (charts_id)=(1) is not present in table "charts".
just to be sure - it means that there's a FK pointing from table section_charts to charts_id =1 on table charts which is missing?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
No, it means you're trying to point a foreign key to a non existing primary key, A foreign key is merely a reference to a primary key in another table that primary key must exist for the foreign key to make any sense
+4
Sachin Singh5y ago
You are assigning FK which is not present in the table.
There is no chart having chart_id=1.
0