Hi
It's a foreign key error.
In Your case the Region Table is the Source Table from where the Site Table is linked with Foreign Key
And you are inserting data in the Site table where the Foreign Key Column (region) has no data in the Parent Table Region.
Regards
Kashif Zeeshan
On Sun, Jul 21, 2024 at 9:47 PM Somnath Som <somnath.som@xxxxxxxxxxxx> wrote:
When trying to insert data in a table then getting below error, someone can guide me please how to resolve the issue.
Error: insert or update on table "site" violates foreign key constraint "reg_fkey"
DETAIL: Key (region)=() is not present in table "region".
Traceback (most recent call last):
