Hello Manfred,
 
Did the table named task have child tables? The records whose task_id was 1 were in child tables rather than task?
 
Could you please try following query?
 

INSERT INTO task_history (task_id, user_id, task_date)

SELECT task_id, user_id, task_date

FROM only task

WHERE task_id IN (1, 2, 3);

Best regards.
Samed YILDIRIM
 
 
 
01.04.2020, 16:49, "Heinemann, Manfred (IMS)" <heinemannm@imsweb.com>:

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.