Обсуждение: FK constraint question

Поиск
Список
Период
Сортировка

FK constraint question

От
"Heinemann, Manfred (IMS)"
Дата:

Can something explain why something like the following could happen?

 

INSERT INTO task_history (task_id, user_id, task_date)

SELECT task_id, user_id, task_date

FROM task

WHERE task_id IN (1, 2, 3);

 

ERROR: insert or update on table "task_history" violates foreign key constraint "fk_task_history_task_id"

  Detail: Key (task_id)=(1) is not present in table "task".

 

Thanks,

Manfred



Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.

Re: FK constraint question

От
Steve Midgley
Дата:
On Wed, Apr 1, 2020 at 6:49 AM Heinemann, Manfred (IMS) <HeinemannM@imsweb.com> wrote:

Can something explain why something like the following could happen?

 

INSERT INTO task_history (task_id, user_id, task_date)

SELECT task_id, user_id, task_date

FROM task

WHERE task_id IN (1, 2, 3);

 

ERROR: insert or update on table "task_history" violates foreign key constraint "fk_task_history_task_id"

  Detail: Key (task_id)=(1) is not present in table "task".

 

Would you share the DDL create table and create FK statements? Seems weird for sure, but it would help to have the DDL to diagnose. Also, if you can provide sample data that generates this error, that will help everyone interested to reproduce your issue.

Re: FK constraint question

От
Ashutosh Sharma
Дата:
Hi,

Do you have multiple task table created in your database? 

Can you share the output of \d+ task_history?

On Wednesday, April 1, 2020, Heinemann, Manfred (IMS) <HeinemannM@imsweb.com> wrote:

Can something explain why something like the following could happen?

 

INSERT INTO task_history (task_id, user_id, task_date)

SELECT task_id, user_id, task_date

FROM task

WHERE task_id IN (1, 2, 3);

 

ERROR: insert or update on table "task_history" violates foreign key constraint "fk_task_history_task_id"

  Detail: Key (task_id)=(1) is not present in table "task".

 

Thanks,

Manfred



Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.