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@ericsson.com>:
> > 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
containa value.
I'd say it contains an empty string, and there is no such region.
Yours,
Laurenz Albe
