Re: Data Issue - Mailing list pgsql-admin

From Kashif Zeeshan
Subject Re: Data Issue
Date
Msg-id CAAPsdhcAYcUJYAp2c=mY4-rJtdmY-uBur5jG=ybbu6HcxQT3iw@mail.gmail.com
Whole thread Raw
In response to Data Issue  (Somnath Som <somnath.som@ericsson.com>)
List pgsql-admin
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@ericsson.com> 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):

 

 

pgsql-admin by date:

Previous
From: Somnath Som
Date:
Subject: Data Issue
Next
From: Holger Jakobs
Date:
Subject: Re: Data Issue