Re: FK constraint question

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(at)imsweb(dot)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.
>