| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Holger Jakobs <holger(at)jakobs(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Data Issue |
| Date: | 2024-07-21 20:35:27 |
| Message-ID: | 3567574f6b25ccb037f6893e461c225017231209.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sun, 2024-07-21 at 19:14 +0200, Holger Jakobs wrote:
> 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):
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cainzos Yvan | 2024-07-22 06:01:46 | Containerizing PostgreSQL |
| Previous Message | Holger Jakobs | 2024-07-21 17:14:12 | Re: Data Issue |