Re: Data Issue
| От | Kashif Zeeshan |
|---|---|
| Тема | Re: Data Issue |
| Дата | |
| Msg-id | CAAPsdhcAYcUJYAp2c=mY4-rJtdmY-uBur5jG=ybbu6HcxQT3iw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Data Issue (Somnath Som <somnath.som@ericsson.com>) |
| Список | 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 по дате отправления: