On Wed, Apr 1, 2020 at 6:49 AM Heinemann, Manfred (IMS) <HeinemannM@imsweb.com> wrote:
<= /div>

Can something explain why something like the followi= ng could happen?

=C2=A0

INSERT INTO task_history (task_id, user_id, task_dat= e)

SELECT task_id, user_id, task_date

FROM task

WHERE task_id IN (1, 2, 3);

=C2=A0

ERROR: insert or update on table "task_history&= quot; violates foreign key constraint "fk_task_history_task_id"
=C2=A0 Detail: Key (task_id)=3D(1) is not present in= table "task".

=C2=A0

Would you sh= are the DDL create table and=20 create=20 FK statements? Seems weird for sure, but it would help to have the DDL to d= iagnose. Also, if you can provide sample data that generates this error, th= at will help everyone interested to reproduce your issue.

--00000000000041807c05a23c5ba6-- From samed@reddoc.net Wed Apr 22 15:50:40 2020 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jRHeF-0007FU-Kc for pgsql-sql@arkaria.postgresql.org; Wed, 22 Apr 2020 15:50:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jRHeE-0007kX-IN for pgsql-sql@arkaria.postgresql.org; Wed, 22 Apr 2020 15:50:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jRHeE-0007kQ-AQ for pgsql-sql@lists.postgresql.org; Wed, 22 Apr 2020 15:50:50 +0000 Received: from forward501o.mail.yandex.net ([2a02:6b8:0:1a2d::611]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jRHeA-0000xq-OV for pgsql-sql@lists.postgresql.org; Wed, 22 Apr 2020 15:50:49 +0000 Received: from mxback30j.mail.yandex.net (mxback30j.mail.yandex.net [IPv6:2a02:6b8:0:1619::230]) by forward501o.mail.yandex.net (Yandex) with ESMTP id 4B6DA1E80AD2; Wed, 22 Apr 2020 18:50:42 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback30j.mail.yandex.net (mxback/Yandex) with ESMTP id dourEILe0G-oeVmQOSH; Wed, 22 Apr 2020 18:50:41 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1587570641; bh=lQtpENC3ioluzL06T0Zd9mDGGfd5bJs/lyFdSFzB3+w=; h=References:Date:Message-Id:Subject:In-Reply-To:To:From; b=Onj0Ne6uo4P+acOW13QPnZTeIz1oVyTqrgUsqAaoWe9l1N3nSWhNmArGec63er3cK 7nYE7M7S2wmTCkulvgfdojBcNNUmg1U26pSPCTz+88PJdyWYWQZI6g/x/ekTlriWvZ Li7ENKgVKjLL5OGw0V9xU1diXxouRtZUYtAPrXjs= Authentication-Results: mxback30j.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by iva3-67f911cb3a01.qloud-c.yandex.net with HTTP; Wed, 22 Apr 2020 18:50:40 +0300 From: Samed YILDIRIM To: "Heinemann, Manfred (IMS)" , "pgsql-sql@lists.postgresql.org" In-Reply-To: References: Subject: Re: FK constraint question MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 22 Apr 2020 18:50:40 +0300 Message-Id: <580931587570375@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IZWxsbyBNYW5mcmVkLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkRpZCB0aGUgdGFibGUg bmFtZWQgPGVtPnRhc2s8L2VtPiBoYXZlIGNoaWxkIHRhYmxlcz8gVGhlIHJlY29yZHMgd2hvc2Ug dGFza19pZCB3YXMgMSB3ZXJlIGluIGNoaWxkIHRhYmxlcyByYXRoZXIgdGhhbiA8ZW0+dGFzaz88 L2VtPjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkNvdWxkIHlvdSBwbGVhc2UgdHJ5IGZvbGxvd2lu ZyBxdWVyeT88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2Nh bGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFw dCAwaW4iPklOU0VSVCBJTlRPIHRhc2tfaGlzdG9yeSAodGFza19pZCwgdXNlcl9pZCwgdGFza19k YXRlKTwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250 LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPlNFTEVDVCB0YXNrX2lkLCB1 c2VyX2lkLCB0YXNrX2RhdGU8L3A+PHAgc3R5bGU9ImZvbnQtZmFtaWx5OidjYWxpYnJpJyAsIHNh bnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBpbiAwaW4gMC4wMDAxcHQgMGluIj5GUk9N IDxlbT48c3Ryb25nPm9ubHk8L3N0cm9uZz48L2VtPiB0YXNrPC9wPjxwIHN0eWxlPSJmb250LWZh bWlseTonY2FsaWJyaScgLCBzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxMXB0O21hcmdpbjowaW4gMGlu IDAuMDAwMXB0IDBpbiI+V0hFUkUgdGFza19pZCBJTiAoMSwgMiwgMyk7PC9wPjwvZGl2PjxkaXY+ QmVzdCByZWdhcmRzLjwvZGl2PjxkaXY+U2FtZWQgWUlMRElSSU08L2Rpdj48ZGl2PsKgPC9kaXY+ PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjAxLjA0LjIwMjAsIDE2OjQ5LCAiSGVpbmVt YW5uLCBNYW5mcmVkIChJTVMpIiAmbHQ7aGVpbmVtYW5ubUBpbXN3ZWIuY29tJmd0Ozo8L2Rpdj48 YmxvY2txdW90ZT48ZGl2IGxhbmc9IkVOLVVTIj48ZGl2PjxwIHN0eWxlPSJmb250LWZhbWlseTon Y2FsaWJyaScgLCBzYW5zLXNlcmlmO2ZvbnQtc2l6ZToxMXB0O21hcmdpbjowaW4gMGluIDAuMDAw MXB0IDBpbiI+Q2FuIHNvbWV0aGluZyBleHBsYWluIHdoeSBzb21ldGhpbmcgbGlrZSB0aGUgZm9s bG93aW5nIGNvdWxkIGhhcHBlbj88L3A+PHAgc3R5bGU9ImZvbnQtZmFtaWx5OidjYWxpYnJpJyAs IHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBpbiAwaW4gMC4wMDAxcHQgMGluIj7C oDwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNp emU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPklOU0VSVCBJTlRPIHRhc2tfaGlz dG9yeSAodGFza19pZCwgdXNlcl9pZCwgdGFza19kYXRlKTwvcD48cCBzdHlsZT0iZm9udC1mYW1p bHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAw LjAwMDFwdCAwaW4iPlNFTEVDVCB0YXNrX2lkLCB1c2VyX2lkLCB0YXNrX2RhdGU8L3A+PHAgc3R5 bGU9ImZvbnQtZmFtaWx5OidjYWxpYnJpJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFy Z2luOjBpbiAwaW4gMC4wMDAxcHQgMGluIj5GUk9NIHRhc2s8L3A+PHAgc3R5bGU9ImZvbnQtZmFt aWx5OidjYWxpYnJpJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBpbiAwaW4g MC4wMDAxcHQgMGluIj5XSEVSRSB0YXNrX2lkIElOICgxLCAyLCAzKTs8L3A+PHAgc3R5bGU9ImZv bnQtZmFtaWx5OidjYWxpYnJpJyAsIHNhbnMtc2VyaWY7Zm9udC1zaXplOjExcHQ7bWFyZ2luOjBp biAwaW4gMC4wMDAxcHQgMGluIj7CoDwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmkn ICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4i PkVSUk9SOiBpbnNlcnQgb3IgdXBkYXRlIG9uIHRhYmxlICJ0YXNrX2hpc3RvcnkiIHZpb2xhdGVz IGZvcmVpZ24ga2V5IGNvbnN0cmFpbnQgImZrX3Rhc2tfaGlzdG9yeV90YXNrX2lkIjwvcD48cCBz dHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDtt YXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPsKgIERldGFpbDogS2V5ICh0YXNrX2lkKT0oMSkg aXMgbm90IHByZXNlbnQgaW4gdGFibGUgInRhc2siLjwvcD48cCBzdHlsZT0iZm9udC1mYW1pbHk6 J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6MTFwdDttYXJnaW46MGluIDBpbiAwLjAw MDFwdCAwaW4iPsKgPC9wPjxwIHN0eWxlPSJmb250LWZhbWlseTonY2FsaWJyaScgLCBzYW5zLXNl cmlmO2ZvbnQtc2l6ZToxMXB0O21hcmdpbjowaW4gMGluIDAuMDAwMXB0IDBpbiI+VGhhbmtzLDwv cD48cCBzdHlsZT0iZm9udC1mYW1pbHk6J2NhbGlicmknICwgc2Fucy1zZXJpZjtmb250LXNpemU6 MTFwdDttYXJnaW46MGluIDBpbiAwLjAwMDFwdCAwaW4iPk1hbmZyZWQ8L3A+PC9kaXY+wqA8aHIg Lz48YnIgLz48Zm9udCBmYWNlPSJBcmlhbCIgc2l6ZT0iMSI+SW5mb3JtYXRpb24gaW4gdGhpcyBl LW1haWwgbWF5IGJlIGNvbmZpZGVudGlhbC4gSXQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIGFk ZHJlc3NlZShzKSBpZGVudGlmaWVkIGFib3ZlLiBJZiB5b3UgYXJlIG5vdCB0aGUgYWRkcmVzc2Vl KHMpLCBvciBhbiBlbXBsb3llZSBvciBhZ2VudCBvZiB0aGUgYWRkcmVzc2VlKHMpLCBwbGVhc2Ug bm90ZSB0aGF0IGFueSBkaXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24sIG9yIGNvcHlpbmcgb2Yg dGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBoYXZlIHJl Y2VpdmVkIHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgb2Yg dGhlIGVycm9yLjwvZm9udD48L2Rpdj48L2Jsb2NrcXVvdGU+ From ashu.coek88@gmail.com Wed Apr 22 16:31:08 2020 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jRIHJ-0000K9-PN for pgsql-sql@arkaria.postgresql.org; Wed, 22 Apr 2020 16:31:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jRIHI-0004Pg-ED for pgsql-sql@arkaria.postgresql.org; Wed, 22 Apr 2020 16:31:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jRIHI-0004OI-7T for pgsql-sql@lists.postgresql.org; Wed, 22 Apr 2020 16:31:12 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jRIHG-00022C-8r for pgsql-sql@lists.postgresql.org; Wed, 22 Apr 2020 16:31:11 +0000 Received: by mail-yb1-xb33.google.com with SMTP id l5so1495703ybf.5 for ; Wed, 22 Apr 2020 09:31:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=kS5Xavd0eDY8s/Zl+rebxuAEwLS1D/10U9OnOgCpP6M=; b=FLN7dcxXODFXmq904kUqUJFUjuDcUDHSNM0O1XG28LLo95q1G5/buS5rfQE7cZ7rlt lf3oM3fBSAoL8oc/We3BDE/ghS4jHQcxUxrTB4QKzF7orAyHDdLz50PrZRmdyBxKliDv 4cUmFx7G7DfFqsaUkp2qoziedV1fw+EwxzKazF1JexVc+tLOrZ5iZzY0czCBUFMvbBwa 9OKeA7nFqoWxJ/uBBiE6eaYtKE9frYgypYh9WwxzHoSv7rdlaZE+wY1L+2rdc1bEQabk x+4Rf7s2DJfkaWT34PA5SW1ZJNcYqGtXjQdFt/pdUSDR8v9R5FBY839Zh1ojQXlTSjT4 UNrw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=kS5Xavd0eDY8s/Zl+rebxuAEwLS1D/10U9OnOgCpP6M=; b=IIaAT08nEc0k7uAU0pzpxDED5tuyVF2cdmbrzbHjrICzUdUrWmR4QLVugH3u/0zeBJ pk6OMCLq+yNVsodgLkA/hy3uqpEqGeyb/4sem5x5jDvK6P23JAb+dV+WPTe/IFaWyka5 Aa7aNakh3apDWNg5AoATo3dlvSi/gYdYKJw+k/gDLj/Ff0ziFHDmxhSkJnWfK9vexdhy eOrsFkjuTnjneEJB9s7zPT1D0pJ/GT6sk1JPiNfnm+mYsczAulbavmfoY+Fj/vBiQDai jNrRz09m8UI/ZPPj7bs+srzBSRvdAdUVJFMjascEQpPpZEVfcCJR7OLhC3rrfBX9pYS9 Xuog== X-Gm-Message-State: AGi0PuZvAjpPXsD6MAyThdAR4S2L2Wpqi5YxvL6wesJXoFlnwC/asTyM fV8kOw3jDAYlpHkmcmOQbiDHHauVUfW6Lam0115DNQ== X-Google-Smtp-Source: APiQypL2e57uTydEK90Ppgh/kayugNghHWDauC/ErhLVOQKqCn2cp3oRHLmJ0W1M9nc0DBGLU7bCLfZYyyD2gxup0FA= X-Received: by 2002:a25:e658:: with SMTP id d85mr3267662ybh.481.1587573068549; Wed, 22 Apr 2020 09:31:08 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a25:ab48:0:0:0:0:0 with HTTP; Wed, 22 Apr 2020 09:31:08 -0700 (PDT) In-Reply-To: References: From: Ashutosh Sharma Date: Wed, 22 Apr 2020 22:01:08 +0530 Message-ID: Subject: Re: FK constraint question To: "Heinemann, Manfred (IMS)" Cc: "pgsql-sql@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ce529b05a3e3a8a5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000ce529b05a3e3a8a5 Content-Type: text/plain; charset="UTF-8" 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) 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. > --000000000000ce529b05a3e3a8a5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi,

Do you have multiple task table created in your data= base?=C2=A0

Can you share the output of \d+ task_h= istory?

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

Can something explain why something like the followi= ng could happen?

=C2=A0

INSERT INTO task_history (task_id, user_id, task_dat= e)

SELECT task_id, user_id, task_date

FROM task

WHERE task_id IN (1, 2, 3);

=C2=A0

ERROR: insert or update on table "task_history&= quot; violates foreign key constraint "fk_task_history_task_id"

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

=C2=A0

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 empl= oyee or agent of the addressee(s), please note that any dissemination, dist= ribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please = notify the sender of the error.

--000000000000ce529b05a3e3a8a5--