On Sun, 2024-07-21 at 19:14 +0200, Holger Jakobs wrote: > Am 21. Juli 2024 18:47:06 MESZ schrieb Somnath Som <somnath.som@xxxxxxxxxxxx>: > > 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): > > Every site has to be within a region. The column region of the row you try to insert into the table "site" doesn't contain a value. I'd say it contains an empty string, and there is no such region. Yours, Laurenz Albe
