Re: Data Issue

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Data Issue
Date: 2024-07-21 17:14:12
Message-ID: 6A5436B3-4EF4-4790-BA87-89D815B62119@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Am 21. Juli 2024 18:47:06 MESZ schrieb Somnath Som <somnath(dot)som(at)ericsson(dot)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):
>
>

In response to

  • Data Issue at 2024-07-21 16:47:06 from Somnath Som

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-07-21 20:35:27 Re: Data Issue
Previous Message Kashif Zeeshan 2024-07-21 17:11:00 Re: Data Issue